| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for text
How can I check the cell contents to identify whether the
value is text or not? I thought I could get there with the IsNumeric function: IsNumeric(ActiveCell) returns: A blank cell is true. A number is true. Text is false. So far so good, BUT ... A date (like 3/15/2003) is FALSE! That doesn't work for me. Art |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Testing | Excel Discussion (Misc queries) | |||
| User form - Testing for numbers or text | Excel Discussion (Misc queries) | |||
| Testing | Excel Discussion (Misc queries) | |||
| TESTING | Excel Worksheet Functions | |||
| testing | New Users to Excel | |||
Threaded Mode
