G
Guest
I am trying to move a worksheet that is essentially a bunch of dates to
another excel file to do some linking but everytime I move the sheet, it
changes the dates from 2007 to 2003 and even, in some cases, changes the day
by 1 or 2 days. For example, Aug 31 2007 becomes August 30 2003.
I've changed the formatting to mm-dd-yyyy and that doesn't seem to make a
difference. Copying the sheet to a new sheet in the same workbook works ok
but moving/copying it to another workbook makes the dates change. Anyone have
any ideas?
another excel file to do some linking but everytime I move the sheet, it
changes the dates from 2007 to 2003 and even, in some cases, changes the day
by 1 or 2 days. For example, Aug 31 2007 becomes August 30 2003.
I've changed the formatting to mm-dd-yyyy and that doesn't seem to make a
difference. Copying the sheet to a new sheet in the same workbook works ok
but moving/copying it to another workbook makes the dates change. Anyone have
any ideas?