View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.