View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
art art is offline
external usenet poster
 
Posts: 22
Default 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