validity of a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
Data Validation on Locked Cell 2
Finding Text within an Array 2
Help to validate MULTIPLE numbers in one cell, not just the total 1
Data Validation 4
Data validation 3
Data Validation in another sheet 1
Data Validation? 2

Back
Top