Thanks Frank. I was almost positive it was Harlan, and that's what I used
in most of my searches. However, for some reason, I still can not find that
article anywhere!! Hmm. I don't know.

For the op, if you run into problems trying to figure out if a number is a
date, sometimes using .Value2 can help. It would depend on what you are
using of course.

Dana

"Frank Kabel" wrote in message
...
Dana DeLouis wrote:
Now I have to go through them and make sure they all make sense. ie.
not take a date converted to a number.

A little of topic. Here is an interesting article on Excel
converting Dates to Numbers. I can't find who posted this link
recently to give credit. It's an interesting article as it serves as
a good reminder:

Hi Dana
it was Harlan Grove who posted this some days ago :-)

and I agree: Very interesting article!

Frank