Remove Timestamp from date

[[email protected]]

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)

<[email protected]> wrote in message
news:[email protected]...
> 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
>

[[email protected]]

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)

<[email protected]> wrote in message
news:[email protected]...
> Bob,
>
> That was just beautiful. Works like a charm.
>
> Thank you so much. This will save me tons of time.
>
> Thank You....
>