G Guest Apr 27, 2005 #1 I want the user to only be allowed to enter the Char type 'A' or 'D' in this particular cell. Does any know how to accomplish this?
I want the user to only be allowed to enter the Char type 'A' or 'D' in this particular cell. Does any know how to accomplish this?
D Dave Peterson Apr 28, 2005 #2 Does Char type 'A' or 'D' mean the characters A or D? If yes, take a look at Data|Validation. It isn't foolproof (users can paste over the cell), but it works nicely for most.
Does Char type 'A' or 'D' mean the characters A or D? If yes, take a look at Data|Validation. It isn't foolproof (users can paste over the cell), but it works nicely for most.
