You posted the code giving me the implication that it worked. I NOW see way
way down at the bottom you indicate that it didn't (something I didn't see
on before I responded) - sorry, incorrect understanding of the result on my
part - nonetheless, I provided code that does work.

--
Regards,
Tom Ogilvy




"DKY" wrote in message
...

Tom Ogilvy Wrote:
If that works, then all you had to do was select the column and do
Format=Cells. Probably fewer keystrokes than running the macro. And
you
could have formatted the column as mm/dd/yyyy like you said you
wanted.

--
Regards,
Tom Ogilvy


Excel wouldn't let me format a 4 digit number into a date that looks
like mm/dd/yyyy.


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=516924