Search : in
By :

Problem with dates in Excel 2004 MAC

Last answer on Dec 18, 2008 8:37:33 pm GMT Szimitar, on Dec 18, 2008 4:30:58 pm GMT 
 Report this message to moderators

Hello,

I'm working in MAC OSX
MS Office 2004 11.5.3 (081114)

I have two workbooks opened at the same time.
I copied 54K+ rows of data from one sheet from WBK-A into sheet in WBK-B.

Column C has date values (unformatted so they look like integers)

Both sheets contain a cell with value 39782.

When I format that cell in WBK-A as Date:MM/DD/YY it displays 11/30/08
When I format that cell in WBK-B as Date:MM/DD/YY it displays 12/01/12

This happens on many cells not just this one. It does not happen in the first few rows.

My head is about to explode but I know this is either a bug or the result of some
odd (hidden to me) inconsistency in settings between these workbooks or sheets.

Any help much appreciated.
thanks,
Sz

Configuration: Mac OS X
Firefox 3.0.5

Best answers for « problem with dates in Excel 2004 MAC » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL �+ ;� in the chosen cell. To insert current time, press CTRL�+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Ask your question Reply

1

Szimitar, on Dec 18, 2008 5:10:10 pm GMT

Found the answer.

There is a default setting in excel preferences to use 1904 date formatting.
Just uncheck that and dates are the same
.

   
Reply to Szimitar

2

 aquarelle, on Dec 18, 2008 8:37:33 pm GMT

Hi,
Thank you for coming back to give us the solution you have found. You can be sure that this will be helpful.
Best regards "Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."

   
Reply to aquarelle
Ask your question Reply
They need your help