A new version of Primavera P6 Professional has recently dropped: Primavera P6 v21, and I'm here to tell about what's new, what's great and what's not. I feel it's my heartfelt duty to schedulers everywhere to unpack these yearly updates and highlight all of the features that are changing or improving, or are still broken. I love to do it, and I've been doing it for years. Here is the yearly
P6 Export to Excel: Number Formatting Secret
Leave a CommentWe 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! That is because P6 formats all data exports as text (appends an apostrophe in front of all data). This makes getting clean data from P6 (even filtered data) extremely difficult. Often we would like to