Thread: Differentiate between Number and Date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Differentiate between Number and Date?
The nested IF looks like this. Please note you'll need to verify that
the letters for type(A1)=3 and type(a1)=4 are correct:
=IF(TYPE(A1)=1,"A",IF(TYPE(A1)=2,"C",IF(TYPE(A1)=3 ,"D",IF(TYPE(A1)=4,"L",""))))

Reply With QuoteReply With Quote