| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
There is no way to tell if the cell value is a date (at least not full
proof) an excel date is a number so you can test for ISNUMBER and ISTEXT thus the IS functions are the way to go =IF(ISNUMBER(A1),"do this","do that") -- Regards, Peo Sjoblom "sparx" wrote in message ... The IS command does not perform the function needed as there must be another way of working it out. -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| date type format which is supported by excel 2003 | Charts and Charting in Excel | |||
| vlookup argument type | Excel Worksheet Functions | |||
| multiple results display after filter function | Excel Worksheet Functions | |||
| How do I type 24 square metres using arithmetical notation | Excel Discussion (Misc queries) | |||
Threaded Mode
