how to change input to upper case as you type

  • Thread starter Thread starter FDDavis
  • Start date Start date
F

FDDavis

I would like to have a cell formated so if you type in c it will display
as C or ph as PH etc. I think this is probably simple but not for me.
Thanks:
 
You could use data validation to ensure that the end user enters the data in
the cell in uppercase.

To do this, select the cell, click Data / Validation and choose "Custom"
from the list. Assuming the cell is A1, enter the following validation
formula:

=EXACT(A1,UPPER(A1))

To apply this data validation to other cells, copy A1 and click Edit / Paste
Special / Validation to the cell / range to which you'd like to apply it.

If that's not what you're looking for, you can use another column to format
the data as uppercase. For example, if A1:A10 is your data input range, set
B1 to:

=UPPER(A1)

and fill down to B10.

Another option is to use macros to automatically set the values you enter to
uppercase. If that's something you'd consider, I suggest posting to
microsoft.public.excel.programming.

/i.
 
Anything that you put into AutoCorrect will apply to all of MS Office.

I would put changing everything to capitals in the same category
as blinking text, scrolling marquee's, gaudy colors -- it is certainly
not business like.

Certain columns might well be capitalized such as a US 2 letter
postal zip state code. For which you could capitalize them
all at once
http://www.mvps.org/dmcritchie/excel/proper.htm#proper
or with an event macro when entered which you will find under
the same topic.

Event Macros
http://www.mvps.org/dmcritchie/excel/event.htm
are not installed the same as normal macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Anders S said:
Take a look at Tools>Autocorrect.

HTH
Anders Silvén
Click to expand...
 
Thanks I am using cell validation and only allowing upper case C CV or
PM and I am lost on macro's so I will just keep making the users hit
the cap locks key. I was hoping there was a simple way to do it and I
had over looked it. Thanks for the help. I could not get the auto
correct to work either. FD
 
Anything that you put into AutoCorrect will apply to all of MS Office.

You are right of course, David.

My mistake. Disregard my post.

Anders Silvén

David McRitchie said:
Anything that you put into AutoCorrect will apply to all of MS Office.

I would put changing everything to capitals in the same category
as blinking text, scrolling marquee's, gaudy colors -- it is certainly
not business like.

Certain columns might well be capitalized such as a US 2 letter
postal zip state code. For which you could capitalize them
all at once
http://www.mvps.org/dmcritchie/excel/proper.htm#proper
or with an event macro when entered which you will find under
the same topic.

Event Macros
http://www.mvps.org/dmcritchie/excel/event.htm
are not installed the same as normal macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Click to expand...
 
Back
Top