I get wrong dates when i paste from a different sheet into a new s

M

mmollat

Hello again,

My problem now is when I open an old excel sheet with data on it and try to
paste that info on a new sheet I get wrong information.

example: I'm trying to copy dates from an excel sheet I have. The dates are
for the year 2004. When I copy the data and paste it on a new sheet the dates
I now see are 2000. I'm puzzled. What I find wierd is when I have clipboard
open the information shows the correct dates but when it's actually pasted on
the sheet it shows as 2000.

I'm using Excel 2003, but I get the same thing when using excel 2002(xp)

Thanks for your help,
Mark
 
M

mmollat

These forums kick butt! Thanks Jason for the quick reply. I checking that
1904 date system and it worked perfect!

Mark
 
Top