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

"Glenn" wrote:

Describe in some detail "not working" and "data gets corrupted".


robin l wrote:
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.



Possibly dumb question, but exactly how are you copying and pasting?


Format the cell containing 10/1/08 as a number instead of a date (easiest way is
to click on the comma on the Formatting toolbar). Does it display "39,722.00"
now? Or "39,457.00" (I don't know if you are using m/d/y or d/m/y)?

If either number above is correct, copy it and paste it into the other
worksheet. What does that display? If it is the same as in the original
worksheet, then format it as a date. Now what does it display?