Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Data Validation for specific text and numbers only
Hi Everyone
I need to create a custom data validation rule for an entire column to allow the following data types only: 1. numbers greater than 0 2. Specific Letters: "c", "C', "N", and "n". So Far I've come up with this formula: =OR(AND(ISNUMBER(E5),E50),EXACT(E5,"n"),EXACT(E5, "N"),EXACT(E5,"C"),EXACT(E5,"c")) However, I cannot use the "apply these changes to all other shells with the same settings" option because I'm using the "EXACT" feature. I would greatly appreciate any help at all... Thank you in advance for any suggestions, Antonio |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Data Validation for specific text and numbers only
Check your earlier post.
Antonio wrote: Hi Everyone I need to create a custom data validation rule for an entire column to allow the following data types only: 1. numbers greater than 0 2. Specific Letters: "c", "C', "N", and "n". So Far I've come up with this formula: =OR(AND(ISNUMBER(E5),E50),EXACT(E5,"n"),EXACT(E5, "N"),EXACT(E5,"C"),EXACT(E5,"c")) However, I cannot use the "apply these changes to all other shells with the same settings" option because I'm using the "EXACT" feature. I would greatly appreciate any help at all... Thank you in advance for any suggestions, Antonio -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Data Validation for specific text and numbers only
Thanks Dave!
"Antonio" wrote: Hi Everyone I need to create a custom data validation rule for an entire column to allow the following data types only: 1. numbers greater than 0 2. Specific Letters: "c", "C', "N", and "n". So Far I've come up with this formula: =OR(AND(ISNUMBER(E5),E50),EXACT(E5,"n"),EXACT(E5, "N"),EXACT(E5,"C"),EXACT(E5,"c")) However, I cannot use the "apply these changes to all other shells with the same settings" option because I'm using the "EXACT" feature. I would greatly appreciate any help at all... Thank you in advance for any suggestions, Antonio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Data Val for specific text and numbers only | Excel Discussion (Misc queries) | |||
Custom Data Validation | Excel Discussion (Misc queries) | |||
How can I show text and numbers in data validation? i.e. L1234 | Excel Discussion (Misc queries) | |||
Custom Data Validation | Excel Discussion (Misc queries) | |||
Custom data validation | Excel Discussion (Misc queries) |