Validation Formula
 

I am trying to allow cell validation for two different data types in a cell.
The data will be restricted to (text "N/A" OR A ten digit number) - I was
able to create validation for both of these types of data (individually), but
I would like excel to allow either one of these types of data ONLY in the
same cell.

Validation Formula
 

You can use allow custom and a formula like this


=OR(A1="N/A",AND(ISNUMBER(A1),LEN(A1)=10))


this assumes there are no leading zeros in the 10 digit number


Regards,

Peo Sjoblom


Teddy-B wrote:
I am trying to allow cell validation for two different data types in a cell.
The data will be restricted to (text "N/A" OR A ten digit number) - I was
able to create validation for both of these types of data (individually), but
I would like excel to allow either one of these types of data ONLY in the
same cell.

Validation Formula
 

Thanks Peo - That formula did the trick like magic. It made sense to me after
analyzing the formula, but I would have never had a clue on how to put it
together. "Thanks" for your quick response and for lending your knowledge to
help.
Regards:
Teddy

"Teddy-B" wrote:

I am trying to allow cell validation for two different data types in a cell.
The data will be restricted to (text "N/A" OR A ten digit number) - I was
able to create validation for both of these types of data (individually), but
I would like excel to allow either one of these types of data ONLY in the
same cell.

Validation Formula
 

My Pleasure


Peo

Teddy-B wrote:
Thanks Peo - That formula did the trick like magic. It made sense to me after
analyzing the formula, but I would have never had a clue on how to put it
together. "Thanks" for your quick response and for lending your knowledge to
help.
Regards:
Teddy

"Teddy-B" wrote:

I am trying to allow cell validation for two different data types in a cell.
The data will be restricted to (text "N/A" OR A ten digit number) - I was
able to create validation for both of these types of data (individually), but
I would like excel to allow either one of these types of data ONLY in the
same cell.