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

J

JE McGimpsey

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.
 
M

Myrna Larson

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.
 
Top