Skip to content
ProjectControls.com
Oracle Primavera - PM6

how to change dates from exported spreadsheet in XL

In the Open Standard
Irfan KhanMember for 17 years 3 months
Created
3
2
0
السلام عليكم ورحمة الله وبركاته

Hi to all,

i exported my project in Spreadsheet (XLS) format.

In that XL format the format of date is like that - ’9/3/2007 8:00:00 AM.

But i want to change these format in like this -
03-Sept-2007.

So from where i hv to change these dates from Primavera or XL.

regards,,,,

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    #1
    Irfran,
    Export files are in text format. If you need to change the format highlight the column that need to change then press ctrl+h (Replace Command) then enter ‘ on Find what text box and leave replace with blank then click replace all. Then press ctrl+1 (Format Cell command) then format it by date format you wanted.
    Report
  2. 0
    Victor Egnora ·
    #2

    Hi Rodel, Thanks for the tip,

    Hi Rodel,

    Thanks for the tip, it spare us from lengthy process just to arrive on a proper date format.

    Please share your wisdom on how to update a programme using excell, and how important are the templates. I tried it once but I messed up the WBS.

    Thanks

    Report
  3. 0
    Mai Tawfeq ·
    #3

    dear vector: the WBS column

    dear vector:

    the WBS column in one of the column unteachable at all ,this happened with me one time i lost the WBS the reasoned  by modifying in WBS column in EXL.

    regards.

    Mai

    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?