Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Corruption
Hi There
When copying a data table from Word to Excel, the date format becomes corrupted. Midway through the data the date changes from 11/12/2006 15:29:20 to 11/13/2006 2:08:40 AM. In the Word document the format remains consistent. Any suggestions would be greatly appreciated. Thanks Brett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Corruption
Brett
You sure it changes from 11/12/2006 to 11/13/2006? Maybe changes to 11/13/2010 which would indicate your Excel is using the 1904 date system which adds 4 years and 1 day. Check at ToolsOptionsCalculation Gord Dibben MS Excel MVP On Mon, 30 Apr 2007 02:12:03 -0700, Brett wrote: Hi There When copying a data table from Word to Excel, the date format becomes corrupted. Midway through the data the date changes from 11/12/2006 15:29:20 to 11/13/2006 2:08:40 AM. In the Word document the format remains consistent. Any suggestions would be greatly appreciated. Thanks Brett |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Corruption
I assume that the later ones are being treated as text, as Excel doesn't
recognise month 13, but does recognise month 12. If you are getting confused between dd/mm/yyyy and mm/dd/yyyy, then it's worth checking your Windows regional settings. -- David Biddulph "Brett" wrote in message ... Hi There When copying a data table from Word to Excel, the date format becomes corrupted. Midway through the data the date changes from 11/12/2006 15:29:20 to 11/13/2006 2:08:40 AM. In the Word document the format remains consistent. Any suggestions would be greatly appreciated. Thanks Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data corruption | Excel Discussion (Misc queries) | |||
Screen corruption and more | Excel Discussion (Misc queries) | |||
Corruption in Excel? | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
formula corruption | Excel Worksheet Functions |