Another way could be to use Data Validation, with a Custom formula

=EXACT(A1,UPPER(A1))

which will prevent any lowercase entry.

Dave

url:http://www.ureader.com/msg/104234538.aspx