You can use VBA code or use Data validation

Maybe you like this without code

Select Column A
Data Validation:(choose custom)

=EXACT(A1,UPPER(A1))

You can only type in Uppercase now




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sonia" wrote in message ...
How can I format a cell to capitize whatever is in ther automatically?