Primavera P6

When I export files from P6 to excel , the numbers are tranferred as TEXT. Can we get the numbers exported in number format

R
Rafael Davila 👤 Member for 22 years 3 months

That is weird. I did not know that, and what about the colors of your reports, into what they are converted?

Report to Excel

Regards,

Rafael

B
Bill D. 👤 Member for 18 years 8 months

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

M
Mike Testro 👤 Member for 20 years 5 months

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

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