I have a spreadsheet with many dates in it. I Select All and then press
Ctrl-C to copy it to the clipboard. Then, I go to another Workbook and
click into the Sheet 4 and click on the same box in the upper left corner
and press Ctrl-V to paste all the data from the original worksheet into the
new one.
The problem is that ALL the dates are changed in the new spreadsheet. For
example the date in cell b:6 in the first sheet is 10/1/05 and when it is
pasted into the new sheet it is 9/31/01. All the other dates are about 4
years off.
Does anyone have any clue what this is all about?
TIA,
Tom
Bookmarks