Can't be done with formatting. You can do it with an event macro (VBA).
The archives

http://groups.google.com/advanced_gr...ugroup=*excel*

have lots of examples. For instance:


http://groups.google.com/group/micro...amming/tree/br
owse_frm/thread/939824c77c99da47/2ef3a9722e83a170


In article ,
"Paul" wrote:

Hi there
Does anyone know whether and if so how to format a cell so that text will
covert to CAPITAL even if the entry is done in lower case?

Thanks