Exporting Dates in Formats so Excel will Read them as Dates RRS feed

  • Question

  • 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?



    Friday, June 22, 2018 7:13 PM

All replies

  • 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.


    Friday, June 22, 2018 9:01 PM
  • OK, thanks a lot John
    Wednesday, June 27, 2018 5:32 PM
  • Bill,

    You're welcome and thanks for the feedback.


    Wednesday, June 27, 2018 6:17 PM