Cell Format - Field Size
 

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

Cell Format - Field Size
 

check data-validation-setting and select text size

"Access Front End" wrote:

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

Cell Format - Field Size
 

Assume cell is A2

Select A2
Click Data Validation,
Allow: Custom
Formula:
=AND(ISNUMBER(A2),LEN(A2)=2)
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Access Front End" wrote:
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