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.