Skip to content
ProjectControls.com
Oracle Primavera - PM6

Exported dates in Excel

In the Open Standard
Thomas NicholsonMember for 20 years
Created
1
2
0

Morning all,

I've been asked by a chap in our office about exported data in Excel. He's exported his activities into excel but the dates appear to be in Lotus format having a ' at the start of the date making calculation difficult and also including the time. Does anyone know if there's a setting I've missed to allow him to do it so it's in normal excel date format?

thanks in advance,

 

Thom

Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Thomas Nicholson ·
    #1

    Update - I've been reading a

    Update - I've been reading a lot of similar posts but they all seem to end with someone suggesting the replace command which unfortunately claims Excel can't find ' on the item that needs changing.

     

    thanks

    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?