Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Query
Hi,
I would be most grateful if someone could offer some advice. I need to set some kind of validation on columns to only except a 10 digit number and nothing else. For example if a 9 or 11 digit number is added an error message is displayed. Is this possible? Kind regards, Simon. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Query
Set the ALLOW field to "Custom" then enter this formula:
=AND(ISNUMBER(A1),LEN(A1)=10) Change A1 to reference the active cell in whatever range you are using. HTH, Elkar "SiH23" wrote: Hi, I would be most grateful if someone could offer some advice. I need to set some kind of validation on columns to only except a 10 digit number and nothing else. For example if a 9 or 11 digit number is added an error message is displayed. Is this possible? Kind regards, Simon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Query | Excel Discussion (Misc queries) | |||
Validation query | Excel Worksheet Functions | |||
data validation query | Excel Worksheet Functions | |||
Data Validation Query | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) |