when I copy and past date...

[mslaurie]

I get a different date. The formatting for the column is the same.
01/03/01.
But when I copy and paste 02/04/07 the pasted date appears as
02/04/11. What's going on?

 

[mslaurie]

I get a different date. The formatting for the column is the same.
01/03/01.
But when I copy and paste 02/04/07 the pasted date appears as
02/04/11. What's going on?

P.S. I'm on a mac running 10.4.8, and this only happens when I copy
into a new document.

 

[CyberTaz]

Apparently you're copying from a workbook set for the 1900 date system
(probably a PC file) & pasting into a workbook which is set to employ the
1904 date system rather than 1900 (probably the Mac file) - go to
Excel>Preferences>Calculation & remove the 1904 check. Remember you're
copying the *date value* stored in the cell regardless of how the cell's
content *appears* based on its formatting. Note that this is a file-specific
setting.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[mslaurie]

Wow, thank you so much! Yes, the doc was prepared on a pc and I'm
working on a mac. That fixes the problem.

 

[JE McGimpsey]

Apparently you're copying from a workbook set for the 1900 date system
(probably a PC file) & pasting into a workbook which is set to employ the
1904 date system rather than 1900 (probably the Mac file) - go to
Excel>Preferences>Calculation & remove the 1904 check. Remember you're
copying the *date value* stored in the cell regardless of how the cell's
content *appears* based on its formatting. Note that this is a file-specific
setting.

In addition to CyberTaz's solution, you can correct the dates in place
by:

1) Enter the value 1462 in a cell.
2) Copy the cell
3) Select the dates to change and choose Edit/Paste Special, selecting
the Values and Add (1904->1900) or Subtract (1900->1904) radio buttons,
then clicking OK.

 

[CyberTaz]

Glad it helped & thanks for the confirmation.