What data validation should I use if I want text but not number?

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

Guest

Hi

Please could you help me

I want to enter text only (NO NUMBERs ALLOWED) What should I type.


Chris
 
Try putting the following into the validation rule of the field in the
table:

Not Like "*[0-9]*"
 
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

Excel Help to copy information from one row at a time to another sheet 1
Which CPU I should choose for coding and multitasking? 0
Excel Sequential Numbering System 0
How to type each letter of the alphabet automatically in a specific color in Word? 0
DataBase 5
If formula and Data Validation parallely 1
Excel Subtract text after the third space and before the fourth (from between spaces) 3
MS word Find and Replace using Regex - Help required 0

Back
Top