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
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!