Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 - excel 97
Hi!
When I moove table from 2003 to 97 the datum in cells changes from t. ex. jan 1 2005 to jan 1 2009 - why? I've tested it on two PC with the same result. W |
#2
|
|||
|
|||
Go to ToolsOptions and the Calculation tab, check if the 1904 date system
is set. -- HTH RP (remove nothere from the email address if mailing direct) "WMA" wrote in message ... Hi! When I moove table from 2003 to 97 the datum in cells changes from t. ex. jan 1 2005 to jan 1 2009 - why? I've tested it on two PC with the same result. W |
#3
|
|||
|
|||
The PC with 2009 is using 1904 date system under toolsoptionscalculations,
before you change back, note that any dates you already created with excel 97 will be off 1462 days if you change it, so if you created native dates with 97, after you changed back, put 1462 in an empty cell, copy it, select the dates thar are 4 years off and do editpaste special and select add Regards, Peo Sjoblom "WMA" wrote: Hi! When I moove table from 2003 to 97 the datum in cells changes from t. ex. jan 1 2005 to jan 1 2009 - why? I've tested it on two PC with the same result. W |
#4
|
|||
|
|||
Bob Phillips skrev:
Go to ToolsOptions and the Calculation tab, check if the 1904 date system is set. Is it MacIntosh date system? I don't have any 1904 date system there. W |
#5
|
|||
|
|||
Hi
if you use a Mac, yes it should be this option -- Regards Frank Kabel Frankfurt, Germany "WMA" schrieb im Newsbeitrag ... Bob Phillips skrev: Go to ToolsOptions and the Calculation tab, check if the 1904 date system is set. Is it MacIntosh date system? I don't have any 1904 date system there. W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Automatic links in Excel 2003 | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |