I need a cell to only alow input of 6 letters or number.

  • Thread starter Thread starter lherndo
  • Start date Start date
L

lherndo

no more, no less. How can I make user only allowed to put in
characters
 
Take a look at Validation in XL Help. Specifically set

Allow: Text Length
Minimum: 6
Maximum: 6

Note that this will still allow an entry of

123.45

If you want to restrict the entry to only letters or numbers (not
punctuation, etc.), you'll need to use a VBA Event macro. Post back if
you need help with that.
 
Just some additional comments re Validation:

It won't preclude you from entering more than 6 characters. You get a message
*after* you've finished the entry (pressed ENTER or TAB), and it's rejected.
 
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

make cell contain only 1 letter/number then tab automatically 3
Excel Sum numbers in cells that also contain text 34
Combining Letters and Numbers 1
Creating sequential numbers plus a letter 4
Cell Formats - Limit # of characters 3
How do I set more then 3 Condition for a cell? 3
Split cell based on uppercase letter 2
Data Input Validation 5

Back
Top