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! 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
Blog > Archives for number formatting