M
Mark Christensen
I've got Excel 2002 SP2. Another person in our office has Excel 2000. She
entered a bunch of data into a spreadsheet for me (the data is dates in
mm/dd/yyyy format). When I copy and paste her data into a new spreadsheet
in one of my existing files, the dates change.
This seems to be the rule of what is happening: when I copy and paste a
cell into my sheet, it adds 1 to the day and 4 to the year. For example, if
she typed 12/18/2003, it pastes it as 12/19/2007; if she typed 4/15/2004, it
pastes as 4/16/2008. We are both baffled by this. There are no formulas
being used, just a basic shreadsheet.
Has anyone seen this before? And does anyone know how to fix it? Thanks in
advance.
Mark
entered a bunch of data into a spreadsheet for me (the data is dates in
mm/dd/yyyy format). When I copy and paste her data into a new spreadsheet
in one of my existing files, the dates change.
This seems to be the rule of what is happening: when I copy and paste a
cell into my sheet, it adds 1 to the day and 4 to the year. For example, if
she typed 12/18/2003, it pastes it as 12/19/2007; if she typed 4/15/2004, it
pastes as 4/16/2008. We are both baffled by this. There are no formulas
being used, just a basic shreadsheet.
Has anyone seen this before? And does anyone know how to fix it? Thanks in
advance.
Mark