Exporting Dates in Formats so Excel will Read them as Dates


  • Is there a way to set MS Project 2010 such that when it exports DATES to Excel, they show up as date-formatted dates that Excel can recognize as dates rather than as text?



    Freitag, 22. Juni 2018 19:13

Alle Antworten

  • Bill,

    Unfortunately no, not with an export map. All data exported with an export map is text data so you need to convert the dates once they get into Excel. If instead of an export map you use VBA to export Project data to Excel, then you can format the data any way you need.

    Hope this helps.


    Freitag, 22. Juni 2018 21:01
  • OK, thanks a lot John
    Mittwoch, 27. Juni 2018 17:32
  • Bill,

    You're welcome and thanks for the feedback.


    Mittwoch, 27. Juni 2018 18:17