Format cell to accept only specific character-reject others
Select the cell, then select "Validation" from the "Data" menu. Select
"Custom", then enter the following formula:
=or(A1="H",A1="F")
Replace A1 with whatever cell you are using.
HTH,
Elkar
"aetzkin" wrote:
I am trying to format a cell so that it will only accept the characters H or
F and reject all others.
|