Type 1462 in an unused cell formatted to General.

Copy it and select the range of date.

EditPaste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Wed, 26 Aug 2009 10:16:02 -0700, 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