April 17th, 2009, 09:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|
PASTE DOESNT WORK
Must admit i had assumed that the OP simply threw in what they believed to
be a couple of representative dates as opposed to actual values.
Regards
Ken..................
"Glenn" wrote in message
...
I though about that, but 10/1/08 doesn't convert to 4/2/03 for me when I go
between date systems...
October 1, 2008 becomes September 30, 2004
January 10, 2008 becomes January 9, 2004
Ken Wright wrote:
Don't worry, you're not going insane. In your workbook that has the 08
date, go to Tools / Options / Calculation and untick the "1904 Date
System" option, which is likely to be the cause.
See here in the section "The Two Date Systems Of Excel" for more info.
http://cpearson.com/excel/datetime.htm
Regards
Ken.......................
"robin l" wrote in message
news
Well, I copy dates and other data from one spreadsheet into another
spreadsheet and different dates and data are pasted that have nothing to
do
with anything. I.e I copy 10/1/08 and 4/2/03 pastes.
Protection is off.
"Glenn" wrote:
robin l wrote:
Can I send someone my spreadsheet - pasting from one spreadsheet to
another
is not working. Dates and other data do not paste correctly and all
my
data gets corrupted.
Thanks,
Robin
Describe in some detail "not working" and "data gets corrupted".
|