Cell Format - Field Size

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
 
G

Guest

Assume cell is A2

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

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

Format Cell and Data Validation 4
How do I have a linked cell auto-size to fit the linked data? 2
Excel Leading Zeros 3
Custom Date Format 3
gauges 4
Copying the data in and format of a cell to another cell 1
Excel 2007 automatically corrupts my data!! 1
Trying to run excel vba code when cell value changes from empty to entered value. 1

Top