View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SwordAngel SwordAngel is offline
external usenet poster
 
Posts: 3
Default How do I validate the datatype of a cell's value in Excel 2007?

Apparently it was possible to validate the datatype of a value in Excel 2003,
by specifying a data validation rule with no maximum and no minimum.

However, this trick does not work in Excel 2007. So how do I validate the
datatype of a cell's value in Excel 2007? I want to avoid VBA for this kind
of work, if at all possible.