On Fri, 9 Apr 2010 17:06:38 -0700, "Fred Smith" wrote:

Thanks, Ron. That's the one that worked for me.

Fred.

By the way, there are other methods that can work also, but the one I posted
seemed the best "self-documenting" one for me.

You could, of course, dim a variable of type Date, and then set the cell equal
to that variable. That would also force the conversion if the cell contents
were text. But, it's not as obvious that is what is going on.
--ron