View Single Post
  #1   Report Post  
Old January 6th 05, 12:39 AM
mmollat
 
Posts: n/a
Default I get wrong dates when i paste from a different sheet into a new s

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