Cell Format - Field Size

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

Guest

Hi !

I trying to create a cell for data entry "State". How's can I format the
cell so that cell only take 2 digits. Is there a option like Access call
"Field Size" that allow you to enter the number of charater ? Thanks

Cathy
 
Assume cell is A2

Select A2
Click Data > Validation,
Allow: Custom
Formula:
=AND(ISNUMBER(A2),LEN(A2)=2)
Click OK
 
Back
Top