Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating a timestamp as a date and time. | Excel Worksheet Functions | |||
Converting UTC timestamp value to date and time | Excel Discussion (Misc queries) | |||
Calculate Elapsed time: difference between 2 Date/Timestamp perio | Excel Worksheet Functions | |||
Convert Unix timestamp to Readable Date/time | Excel Worksheet Functions | |||
SQL Millisecond date to usable excel timestamp | Excel Programming |