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