I get wrong dates when i paste from a different sheet into a new s
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,