View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam :: Oregon, USA Adam :: Oregon, USA is offline
external usenet poster
 
Posts: 1
Default Simple Macro Help

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