Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |