Simple Macro Help

[Guest]

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

 

[Tom Ogilvy]

Selection.NumberFormat = "mm/dd/yyyy"

 

[Paul Lautman]

All date fields are really date time fields.
It is just formatting that make's them show one part or the other.

Press Ctrl-1 and change the number format to one that you prefer.

 

[Guest]

Thank you, but Excel doesn't seem to recognize the cell entry as a date and
time field. I tried the other answer as well as changing the formatting to
eliminate the time, but it doesn't seem to help. I can't change the format
becuase Excel is not viewing the contents as a date with time appended.

Thanks,

Adam

 

[Tom Ogilvy]

select the column

format as the date format you want to see

Edit=>Replace

What: \

With: \

This should cause your data to be reevaluated and seen as dates.

 

[Myrna Larson]

I know you meant a forward slash (/) rather than backslash (\), no?