When I export files from P6 to excel , the numbers are tranferred as TEXT. Can we get the numbers exported in number format
Primavera P6
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
That is weird. I did not know that, and what about the colors of your reports, into what they are converted?
Regards,
Rafael
Betsy,
I believe you cannot directly export data from p6 to be in number format. What you will do is filter and select all number stored as text (in excel file) and click the button that appears and then click convert to number.
Cheers,
Bill
Hi Betsy
If you can't sort it in P6 then you can use the excell conversion formula =(value) that changes the text to values.
Best regards
Mike Testro