Upper Case

  • Thread starter Thread starter Bill Martin
  • Start date Start date
B

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
 
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.
 
Hmm... An upper case only font. I like that as a way to sidestep the problem.
Thanks Dave.

Bill
----------------------
 
Back
Top