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

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



Greegan wrote:

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

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)

----------------------------------------------------------------------------
-----
Greegan wrote in message
...
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