Why not change the format back to working in 1900 system? (if import adds 4
years, changing back to 1900 should subtract 4 years, thus giving correct
dates).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Ille" wrote:

Dear All,
working with Excel 2007, I've received a huge workbook with Dates (e.g. Jan,
12, 2009). The owner of the book has chosen the Dates-Format 1904. When I
import the data, all dates change to four years earlier.
Do you know any possibility for me to work with this worksheets with the
1900-format and still have the correct dates?
Thank you very much in advance
--
Ille