Formatting Cells

[Guest]

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

 

[JE McGimpsey]

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

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

have lots of examples. For instance:


http://groups.google.com/group/microsoft.public.excel.programming/tree/br
owse_frm/thread/939824c77c99da47/2ef3a9722e83a170

 

[Guest]

Hi,
Not in the same column where entries are made.
However, you could have a helper column with the formula,
B2=UPPER(A2), and fill-down the formula in column B.
Regards,
B. R. Ramachandran