Upper Case

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
 
D

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.
 
B

Bill Martin

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top