Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns not working correctly with dates in Excel 2007
I'm using Excel 2007 and when I convert a CSV file using "Text to Column"
menu command when the day is greater than 12 it does not convert the date correctly. As can be seen in my example below hours 10:00 PM and 11:00 PM are handled correctly for January 12 but hours 00:00, 01:00, and 02:00 for January 13 are not. The "Text to Column" menu command works OK on this CSV file in Excel 2003. Any help is appreciated. Format: dd/mmm/yyyy h:mm AM/PM CSV Text to Column ------------------------------- --------------------------------------------- Date_Time,Value Date_Time Value 01/12/2003 22:00:00,689.2, 01/Dec/2003 10:00 PM 689.2 01/12/2003 23:00:00,626.4, 01/Dec/2003 11:00 PM 626.4 01/13/2003 00:00:00,558.8, 01/13/2003 00:00:00 558.8 01/13/2003 01:00:00,530.8, 01/13/2003 01:00:00 530.8 01/13/2003 02:00:00,512.8, 01/13/2003 02:00:00 512.8 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap Text is not working correctly on one persons computer | Excel Discussion (Misc queries) | |||
excel vlookup not working correctly | Excel Worksheet Functions | |||
Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha | Excel Discussion (Misc queries) | |||
Excel 2003 Subtotals not working correctly | Excel Worksheet Functions |