Lock a Cell as Capitols only

[Guest]

How can I format a cell to change text entered in small letters to capitols?
I have tried putting the formula =UPPER(H13) into cell H13, but I get an
error that says circular reference, or if I don't get that it just inserts
the text with small letters without changing it to capitols.

Susan

 

[Guest]

You can use Data Validation to require any data entered to be in ALL CAPS.
Select the cell (we'll say A1 for example), then select "Validation" from the
Data Menu.

Change to "Custom" and enter this formula:

=EXACT(A1,UPPER(A1))

This will not affect data that is already in the cell, nor data that is the
result of a formula. Only data that is manually typed in that cell. The
user will receive an error if they enter any lowercase letters and have to
retype.

HTH,
Elkar