(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.
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
Printer-friendly version
Send to friend
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
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
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
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!
Email: PPadmin@planningplanet.com
Replies