I get two differrent dates for the same serial number. HELP!

[Guest]

Serial number 38470 should be 04/28/05 and I get that in one worksheet. I
copy it into another worksheet and I get 04/29/09. How can I fix this. I
work on large data sets and this is really making my job impossible.

Help!

Thanks - Michael

 

[Oliver Ferns via OfficeKB.com]

Hi,
what version are you using? I cannot replicate this; it always comes back
as 4/28/2005...

O

 

[Ken Wright]

See 'The Two Date systems of Excel'

http://cpearson.com/excel/datetime.htm

 

[Ken Wright]

See my reply to the OP - It's a MAC thing.