Thread: Format Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ille Ille is offline
external usenet poster
 
Posts: 6
Default Format Date

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