Upper Case

[Bill Martin]

Is there a way to specify a special format for a cell to be upper case? I have
cells that I type text into, and I'd like to format it to always display upper
case. I know I can do this with VBA and some programming, but is there a simple
way to just specify a special format for the cell?

I'm using Excel 2003 FWIW...

Thanks.

Bill

 

[Dave Peterson]

You could enter the value and use a formula in another cell:
=upper(a1)

Or use programming.

Or if you only care about the display--not the actual value, you could search
google for an uppercase font and use that.

 

[Bill Martin]

Hmm... An upper case only font. I like that as a way to sidestep the problem.
Thanks Dave.

Bill
----------------------