Format Cell (Number Custom)

B

barryderay

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

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