Updated: May 17, 2018
We all know how to export the Schedules prepared in the Primavera tool into a spreadsheet format, if not view the tutorial just below.
After Exporting, sometimes it needs to be modified further so as to use it for other reporting purposes, updating of the data in excel. But unfortunately the P6 Exports the data as TEXT format and not into the exact existing format. and Simple "Format Cell" Function in Excel wont solve our problem and this needs a small exercise to make the data to handle simpler. A Sample export of the schedule in P6 into an Excel format has been shown below and the tip will be explained further to that.
If you look at the "Duration" in the Column E of the spreadsheet, you will notice apostrophe (') in front of the duration fields. Similarly you will find it in the date fields even
All the data fields will have this apostrophe (') symbol as the data has been exported in the text format.