| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I validate the value and not the formula in excel? | Excel Worksheet Functions | |||
| HOW DO I GET EXCEL TO VALIDATE TWO CELLS AT ONCE | Excel Discussion (Misc queries) | |||
| Save as a dbf file changes datatype | Excel Discussion (Misc queries) | |||
| how to validate excel spreadsheets | Excel Discussion (Misc queries) | |||
| Vlookup datatype(?) issue | Excel Worksheet Functions | |||
Linear Mode
