validity of a cell

M

melirus

hi everybody,
i want to set a cell so that only text (alphabet) can be written there. when someone try to write number there error message will come out.Please help. thank u
 
P

Peo Sjoblom

One way, assume it is A1 that you use, do data>validation>allow>custom

=ISTEXT(A1)*ISERR(--(A1))

won't obviously work for mixed letters and numbers like A2 which
can be entered.

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


melirus said:
hi everybody,
i want to set a cell so that only text (alphabet) can be written there.
Click to expand...
when someone try to write number there error message will come out.Please
help. thank u
 
Top