Thread: Auto Uppercase
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randy Randy is offline
external usenet poster
 
Posts: 213
Default Auto Uppercase

Hello, I have a question pertaining to forcing particular cells into
uppercase text. I have about six cells, all in different rows & columns, that
will have an "x" typed into the cell. I need this "x" to auto-convert to an
uppercase "X". Is there an easy way to do this?

Also, was wondering if there is a way to make these cells automatically
place an uppercase "X" in the cell no matter what letter, number or
charachter the users type? Example, if a user types an "a" or a "c" into the
cell it will automatically convert to an Uppercase "X"...

Any assistance will be greatly appreciated.

I thank you in advance for your time!

--
Randy Street
Rancho Cucamonga, CA