how do I format a cell to display its contents in Upper case?

G

Guest

I'm entering information in a spreadsheet that gets uploaded to a database.
The contents of some of the cells need to be in uppercase.
Is there a way to format the cell in such a way that it changes the case of
the content to upper case. So, if I type in ser, the cell content changes to
SER.
 
G

Guest

you need VBA to do this , not formatting. in the Worksheet_Change event,
Target.value=Ucase(target.Value)
 

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

Formatting cells to only upper case 5
convert lower to upper case automatically without using UPPER 6
Format Cell - Only Upper Case Alpha characters 3
Format cell to convert to Upper case 4
how do i change an existing cell or cells to upper case? 1
1st letter upper case 5
Changing multiple cell text from lower case to upper case 2
change to upper/lower case 1

Top