We are going to multiply all of these numbers by one to transform them into numbers. The “Number Formatting” options in Excel also do not resolve this. If we want to make that correction, we have to go through each cell individually and hit “Enter” to transform it into a number format. I exported a large set of data from P6 into Excel and as you can see, the numbers are positioned to the left in their fields – meaning, they are formatted as text not numbers. When exporting data from Primavera P6 to Excel, we want to make sure that Excel recognizes numbers as numbers.
This following “secret” tip is an even quicker and easier way to solve this issue using multiplication. You would actually have to go through each cell individually to change it from text to number! While you might think this has an easy fix in Excel, using the “Format Cells” function will not change the text data to the data format you require. Often we would like to manipulate the data in Excel (such as performing calculations in Excel using P6 numeric, date or cost data). This makes getting clean data from P6 (even filtered data ) extremely difficult. That is because P6 formats all data exports as text (appends an apostrophe in front of all data). Excel does not seem to recognize numbers as numbers! We all struggle with the same issue when exporting data from Primavera P6 to Microsoft Excel for analysis, progress updating and graphing.