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

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.

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

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

"MarcM" wrote:

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.