Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Very strange date problem !!!!

Status
Not open for further replies.

lode

Programmer
Joined
Nov 8, 2001
Messages
208
Location
BE
I typed in a column of an excel-worksheet a list of dates.
When i reopened that sheet the dates were all changed like this

I typed : This was the result when i reopened the sheet:

12/03/03 08/03/99
13/03/03 09/03/99
14/03/03 10/03/99
15/03/03 11/03/99
16/03/03 12/03/99

As you can see the dayvalues are 4 days earlier .
The yearvalues are 4 years earlier.

I really don't understand what happened here.
The cells do not contain any formulas.

Please help !!
 
It sounds like you had the 1904 date system option set when you entered the dates.

Do menu command Tools/Options/Calculation and tick the 1904 date system tick-box, and see if that fixes it.

Glenn.
 
Yes, i know about the 1904 system date that is used my a Mac.

BUT I saved the sheet with the 1900 date system option set.
I'm very sure about that.

So i don't understand what went wrong !!
 
Hmmm, did you type the dates in including year?

Was this on the same machine that you reopened to workbook on?

If you typed the year in as well as day and month, I don't know what could have caused this ( assuming that you don't have any macros that alter things ).

Glenn.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top