Hi
use the formula EXACT to check for uppercase. e.g. for cell A1
=EXACT(A1,UPPER(A1))

this allows only uppercase entries


--
Regards
Frank Kabel
Frankfurt, Germany


Aaron wrote:
Hi,

I have several columns of cells that I have data
validation on so people do not input data incorrectly.
However the data validation still allows people to input
nj when I want it to be NJ (caps). Is there anyway to
force data validation to recognize caps vs. lowercase.
Thanks in advance.

Aaron