I think this may fall under Data Validation but I'm not sure.

In column A, I want the user to only be able to enter the word
"ACTUALS". It has to be all upper case.

In column B, I want the user to enter a 6 digit account number. The
account number must be 6 characters.

In column C, I want the user to enter an amount that has only 2 decimal
places. This column cannot have more than 2 decimal places.

In column D, I want the user to enter a description (text). This
column cannot include any symbols such as @!#$.-&'()?/,\

If any of the above is in violation I would like an error message to
pop up.


--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=473003