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.
Bookmarks