Skip to content
ProjectControls.com
Oracle Primavera - PM6

Primavera P6

In the Open Standard
Betsy JosephMember for 15 years 11 months
Created
3
1
0

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

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi Betsy If you can't sort it

    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

    Report
  2. 0
    Bill D. ·
    #2

    Betsy, I believe you cannot

    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

    Report
  3. 0
    Rafael Davila ·
    #3

    That is weird. I did not know

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?