Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data to Date conversion with multiple formats
I have a single column of data that includes dates in two formats:
mddyy mddyy hh:mm I tried using the DataText-to-Columns... with mdy to change them to dates. It worked for the mddyy data, but it messed up the mddyy hh:mm data. I need to convert these so I can sort them by yearmonthdayhourminute. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data to Date conversion with multiple formats
If all the dates are in excel date format and not in text format...You can
custom format that to display date in any format along with the time for example m/d/y hh:mm:ss and then the normal sort would sort the dates in sequence.. -- Jacob "adammled" wrote: I have a single column of data that includes dates in two formats: mddyy mddyy hh:mm I tried using the DataText-to-Columns... with mdy to change them to dates. It worked for the mddyy data, but it messed up the mddyy hh:mm data. I need to convert these so I can sort them by yearmonthdayhourminute. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Multiple Date/Time Formats | Excel Worksheet Functions | |||
Date Conversion | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions |