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