format cell to capitlize

[Guest]

How can I format a cell to capitize whatever is in ther automatically?

 

[Ron de Bruin]

You can use VBA code or use Data validation

Maybe you like this without code

Select Column A
Data Validationchoose custom)

=EXACT(A1,UPPER(A1))

You can only type in Uppercase now