Format Cell (Number Custom)
 

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?

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.

barryderay wrote:

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?

--

Dave Peterson