Data Validation
 

I several cells with that needs to contain 9 digits or less, with all of the
characters being numeric. Is there a way I can limit the
characters entered to be all numberic (no alpha, no other characters)?
Thanks for your help.

Data Validation
 

You can use Data Validation (Data Menu) and put in Numeric. You can futher
limit the number to and range by choosing custom and entering a formula

and(F18=0,F18<=999999999)


"JStiehl" wrote:

I several cells with that needs to contain 9 digits or less, with all of the
characters being numeric. Is there a way I can limit the
characters entered to be all numberic (no alpha, no other characters)?
Thanks for your help.

Data Validation
 

Thank you for your help. The problem I run into is I can either choose the
maximum length to be 9 digits in the cell, or I can choose numeric only from
the Data Validation menu. Is there a way I can have both conditions apply?

"Joel" wrote:

You can use Data Validation (Data Menu) and put in Numeric. You can futher
limit the number to and range by choosing custom and entering a formula

and(F18=0,F18<=999999999)


"JStiehl" wrote:

I several cells with that needs to contain 9 digits or less, with all of the
characters being numeric. Is there a way I can limit the
characters entered to be all numberic (no alpha, no other characters)?
Thanks for your help.

Data Validation
 

I tested the validation by putting non-numeric values and it worked fine.
You don't need to add Numeric. There may be problems with dates because they
are stored as numbers in excel.

Youcould add ISNumber to the formula but it will not do anything additional
to the formula without IsNumber.

and(F18=0,F18<=999999999,IsNumber(F18))


"JStiehl" wrote:

Thank you for your help. The problem I run into is I can either choose the
maximum length to be 9 digits in the cell, or I can choose numeric only from
the Data Validation menu. Is there a way I can have both conditions apply?

"Joel" wrote:

You can use Data Validation (Data Menu) and put in Numeric. You can futher
limit the number to and range by choosing custom and entering a formula

and(F18=0,F18<=999999999)


"JStiehl" wrote:

I several cells with that needs to contain 9 digits or less, with all of the
characters being numeric. Is there a way I can limit the
characters entered to be all numberic (no alpha, no other characters)?
Thanks for your help.