Home Forums Discussion Customizing the date format from MS Project to Excel

This topic contains 1 reply, has 1 voice, and was last updated by  Tom Steger 1 week, 2 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #411218 Reply

    Sergio

    Hi There

    I am exporting to excel from my MS Project 2016, using the Project Export Wizard.
    To make things easier I selected the field to map based on a ad hoc table (baseline, forecasts and actuals basically).
    When I open the excel file once the info is exported, cells in Excel are all Text and the dates have different formats:
    – Forecast and baseline start and finish: 15 November 2017 8:00
    – Actuals start and finish: Wed 15/11/17

    Excel do not recognize those as dates…
    What is the criteria for the Project Export Wizard to chose that format?
    Can I change it?

    For the benefit of your understanding I would say that dates in the MS Project table I generated the exportation from is dd/mm/yyy

    Thanks in advance

    #415536 Reply

    Tom Steger

    +1/bump!

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: Customizing the date format from MS Project to Excel
Your information:




+ 12 = 16