Formatting Upper Case letters

[Greegan]

Is there something I can do to make sure a cell on my worksheet shows alpha
characters in upper case even though i might type them in lower case?

thanks

 

[Dave Peterson]

Chip Pearson has some techniques at:
http://cpearson.com/excel/case.htm

 

[Shailesh Shah]

Hi Greegan,

You can download "change case in excel cells" (for excel-2000+) that have
word's change case interface from below site.

http://in.geocities.com/shahshaileshs/

With this, you can also
1. change case of selected text from the textbox in the com-addins
dialogbox.
2. change text case to sentence case.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)