Caps

Posted by Robb on February 05, 2002 6:46 PM

How do I limit the user to type CAPS (no lower case) in my workhseets?

Posted by Jaime on February 05, 2002 8:37 PM

Use data validation.

Select the entire sheet by cliking on the left hand corner . Then goto Data|Validation.
IN validation criteria set Allow to custom and
in the formula put this
=EXACT(A1,UPPER(A1))

Press Ok and you set.
Email me if any questions