custom formatting in excel

[HUSKER55]

I want to format soem text in excel and it wo't let me do it. If I use numbers it works fine.

What is the trick?

Thanks

:)

[cj]

Conditional formatting? What is the text and how are you trying to format it?

[HUSKER55]

What I am trying to do is to format some brackets around some letters.


ie, (ab). (ab) refers to a formula that I want to move into various other ones.

I am trying to make sure the formula is not corrupted hence the brackets. If I use numbers, the brackets are not a problem to get put in. Excel puts the brackets in. But if I use letters it leaves the brackets off and then the order of operations get corrupted.

I am beginning too think I can't do what I want to.

Thanks

[raybo]

What I am trying to do is to format some brackets around some letters.


ie, (ab). (ab) refers to a formula that I want to move into various other ones.

I am trying to make sure the formula is not corrupted hence the brackets. If I use numbers, the brackets are not a problem to get put in. Excel puts the brackets in. But if I use letters it leaves the brackets off and then the order of operations get corrupted.

I am beginning too think I can't do what I want to.

Thanks

Not enough information.

[facorsig]

Try using ' or ^ or " before the parenthesis to identify that you have text. The different symbols will right, center and left justify.

[misscashalot]

I want to format soem text in excel and it wo't let me do it. If I use numbers it works fine.

What is the trick?

Thanks

:)

If you don't get your answer here, then go to
mrexcel.com registration takes a minute and it's free.

[raybo]

What I am trying to do is to format some brackets around some letters.


ie, (ab). (ab) refers to a formula that I want to move into various other ones.

I am trying to make sure the formula is not corrupted hence the brackets. If I use numbers, the brackets are not a problem to get put in. Excel puts the brackets in. But if I use letters it leaves the brackets off and then the order of operations get corrupted.

I am beginning too think I can't do what I want to.

Thanks

Is this what you're trying to do?

[HUSKER55]

YES BUT FOR SOME RESON THE LETTERS WON'T COME OUT. ONLY THE NUMBERS. 55 comes out (55). ab comes out ( )

Thanks

[raybo]

YES BUT FOR SOME RESON THE LETTERS WON'T COME OUT. ONLY THE NUMBERS. 55 comes out (55). ab comes out ( )

Thanks

What version of Excel are you running?

[HUSKER55]

2007 EXCEL

[Snag]

Is it just my poor old eyes or is there a space between the (ab). (ab)? Without the space should it look like (ab).(ab)?

[raybo]

Is it just my poor old eyes or is there a space between the (ab). (ab)? Without the space should it look like (ab).(ab)?

Yeah, I misread his post. He wanted (ab), not (ab). (ab), 2 sentences.

[raybo]

2007 EXCEL

In Excel 2007, I typed: ="(ab)" and got (ab)

Got the same thing in Excel 97-2003. Don't understand why you can't get the same thing.