ExcelBanter - How do I validate the datatype of a cell's value in Excel 2007?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I validate the datatype of a cell's value in Excel 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/221553-how-do-i-validate-datatype-cells-value-excel-2007-a.html)

SwordAngel

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.

All times are GMT +1. The time now is 06:37 PM.