Remove Timestamp from date

[Smythe32]

Hi,

I have a .csv file that I copy into and worksheet and use it for pivot
tables. The problem is that I need to remove the timestamp from the
date so I don't have multiple dates in the pivot dropdowns. I also
need to be able to sort on the date.

I tried picking the field apart with the left and mid functions, but it
will not sort as a date.

Any help would be greatly appreciated.

Thanks

 

[Bob Phillips]

=INT(A1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Smythe32]

Bob,

That was just beautiful. Works like a charm.

Thank you so much. This will save me tons of time.

Thank You....

 

[Bob Phillips]

The simple ones are always the best <g>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)