use Vartype

See help for details.

--
Regards,
Tom Ogilvy

"Jim Watkins" wrote:

I'm liiking for a way to determine which of the following is true regarding
the value & format of a specific cell: Does the cell have a (1)
date-formated number, or (2) a time-formated number, or (3) a numeric value
that is neither date-formated nor time-formated.