in another column you could have =upper(a1) so everything you type in A1
appears in the other cell as upper case
--
paul

remove nospam for email addy!



"Jim Cone" wrote:

The free Excel add-in 'Excel Extras' will change selected cell text to
Upper, Lower, Proper or Sentence case by clicking the appropriate
menu item on the format menu.
It does other stuff too.
Download from... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"butterbean" wrote in message
Is it possible to format, say, a column to automatically convert text
entered in that column to upper case, no matter how the text is
entered?
That is, when the enter/tab is hit, the text will appear in upper case,
no matter what the case when entered.
I am just trying to overcome having to remember to use the caps lock.
--
butterbean