Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 dates
I have a excel spreadsheet with a column of dates that was ceated in Office XP.
Example: 5-May-05 We recently updated to office 2003 and now whenever I copy this column into a different spreadsheet all of the dates change and end in 01 now. |
#2
|
|||
|
|||
check in <tools<options<calculation and see if 1904 date system is checked.
"mdob" wrote: I have a excel spreadsheet with a column of dates that was ceated in Office XP. Example: 5-May-05 We recently updated to office 2003 and now whenever I copy this column into a different spreadsheet all of the dates change and end in 01 now. |
#3
|
|||
|
|||
Saved from a previous post:
One workbook was using a base year of 1900 and the other was using 1904. (tools|options|calculation tab|1904 date system) One way to add those four years back is to find an empty cell, put 1462 into that cell. Copy that cell. Select your range that contains the dates. Edit|PasteSpecial|click Add (in the operation box). You may have to reformat the cell as a date (mine turned to a 5 digit number). But it should work. You may want to do it against a copy...just in case. (I'm not sure which one you'll fix. You may want to edit|pastespecial|click subtract.) Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as the base date. mdob wrote: I have a excel spreadsheet with a column of dates that was ceated in Office XP. Example: 5-May-05 We recently updated to office 2003 and now whenever I copy this column into a different spreadsheet all of the dates change and end in 01 now. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINEST bug in Excel 2003 | Excel Worksheet Functions | |||
trying to open an excel file in excel 2003 | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) |