Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Export dates form P6 to Excel in European format

4 replies [Last post]
Alberto Homedes
User offline. Last seen 7 years 29 weeks ago. Offline
Joined: 17 Nov 2011
Posts: 5
Groups: None

Hi,

I need to export the start and the finish dates from P6 to excel, but I need that when I have this in excel, I can use this information how dates no how text. And I want to know If somebody export to excel, the dates with date format no like text.

Thank you

Replies

mimoune djouallah
User offline. Last seen 8 weeks 5 days ago. Offline
Joined: 14 Oct 2006
Posts: 388

in excel, select the columns, then data, text to columns, delimited, then date, select DMY, finish

excel will change the date format to your computer date format, then you can use the for your reports

Thomas Nicholson
User offline. Last seen 29 weeks 1 day ago. Offline
Joined: 4 Oct 2006
Posts: 62
Groups: None

I suspect he's asking the question I asked last week.

When exporting from P6 the date appears in Excel as

'12-12-11' and using replace will not work as it claims it can't find the ' part you want to replace thus rendering it useless for analysis in Excel.

 

Thom  

Thomas Nicholson
User offline. Last seen 29 weeks 1 day ago. Offline
Joined: 4 Oct 2006
Posts: 62
Groups: None

I suspect he's asking the question I asked last week.

When exporting from P6 the date appears in Excel as

'12-12-11' and using replace will not work as it claims it can't find the ' part you want to replace thus rendering it useless for analysis in Excel.

 

Thom 

Ronald Winter
User offline. Last seen 5 years 21 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None

Alberto,

Are you asking how to format your dates as just a series of numbers?  You do this formatting in Excel.  Highlight the fields (or column) and then right-click, “format cells” and pick the desired way of displaying your dates.  Good luck!