Formatting Cells:covert to CAPITAL

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

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 <[email protected]>,
"Paul" <[email protected]> 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

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

"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