Remove Timestamp from date
 

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

Remove Timestamp from date
 

=INT(A1)

--
HTH

Bob Phillips

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

wrote in message
oups.com...
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

Remove Timestamp from date
 

Bob,

That was just beautiful. Works like a charm.

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

Thank You....

Remove Timestamp from date
 

The simple ones are always the best <g

--
HTH

Bob Phillips

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

wrote in message
ps.com...
Bob,

That was just beautiful. Works like a charm.

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

Thank You....