P6 Export to Excel: Number Formatting Secret
We all struggle with the same issue when exporting data from Primavera P6 to Microsoft Excel for analysis, progress updating and graphing. Excel does not seem to recognize numbers as numbers!
This makes getting clean data from P6 (even filtered data) extremely difficult.
Michael unpacks a quick and easy secret tip for solving this issue!
Learn Primavera P6 as a Beginner, or become a P6 Master:
https://www.planacademy.com/
Check out our Training for Teams page to see how we can help grow your company's project controls skills:
https://www.planacademy.com/teams/
~
TAGS:
P6 import to excel, Excel P6, Primavera P6, Import to Excel, Excel not reading numbers, excel won't add, Michael Lepage, Plan Academy, P6 import trick, P6 export Trick, Excel format help, Project Controls, Free P6 help