View Single Post
  #1   Report Post  
Julie
 
Posts: n/a
Default Trouble with Dates between 2 seperate worksheets

In Excel 2000, I am having trouble with dates retaining when copying a
worksheet from one workbook to another.

For example, in one cell, we have a date of April 8, 2005 and when I copy
the worksheet to another workbook, is changes to April 9, 2009. (it adds 4
years and 1 day)

I have tried several formatting changes - with no luck. HELP PLEASE IT IS
MAKING ME CRAZY!!


--
Julie