Dates corrupt when copy/cut & Paste

A

Art Demers

When I copy any amount of data to a new sheet my date column becomes
corrupted. A date of 11/16/2003 becomes 11/17/2007 and let's say a
date of 2/24/04 becomes 2/25/2008

Any ideas of a solution beside doing a replace evertime?

Thks,

Art
 
B

Bernard Rey

Art Demers wrote :
When I copy any amount of data to a new sheet my date column becomes
corrupted. A date of 11/16/2003 becomes 11/17/2007 and let's say a
date of 2/24/04 becomes 2/25/2008
Click to expand...

It's not a corruption matter, it's a settings matter. One of your sheets has
the Windows standard, the other one the Macintosh standard.

There's a free utility that can help you out, modifying the setting on the
fly, in order to keep things compatible (and letting you choose which
standard you want to keep). It's not totally satisfyingly translated to
English yet, but it's already running fine, give it a try:

http://faq.office.macintosh.free.fr/OfficeFAQ_fichiers/documents/DatexlaEN.s
it
 
Top