Selection.NumberFormat = "mm/dd/yyyy"

--
Regards,
Tom Ogilvy


"Adam :: Oregon, USA" <Adam :: Oregon, wrote
in message ...
Hi all,

I am importing some data into Excel from on old Wang system. I need to
create a date field, but the date field as imported shows up as 1/11/2001
00:00:00. I would really appreciate some help in creating a macro that
eliminates the 00:00:00 so I can just set the field up as a date field and
have it sort correctly.

Thank you,

Adam