Force Caps in a cell??

T

tagr

Is there a way to force text to automatically be show in Upper case eve
though it might have been entered as lower case. So the cel
automatically changes all text into upper case.

I have played with the UPPER command but it seems to only allow th
upper case to be copied into another cell in caps.

Thank
 
T

tagr

Best I can tell this only changes a cells characters to Upper case afte
the text is entered. So if a lower case 'z' is entered you must go bac
to that cell and do ctrl u to make it upper case.

I am looking for something that will force Upper case on the fly.

Thanks for your help -

Jered
Lubbock, T
 

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

Similar Threads

How do I convert addresses to all caps in Office 2007? 3
How do you change the Capitalization in an Excel Workbook? 7
Excel: how to convert text to upper case upon entry? 13
Format Cell - Only Upper Case Alpha characters 3
Uppercase 6
All Caps, / All Lower, not the function 5
Formatting cells to only upper case 5
convert lower to upper case automatically without using UPPER 6

Top