(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,
Whenever I export data from P6 in Excel format the data comes out in a strange format where everything has a "`" in front. For example, 1303FR001 comes out like `1303FR001. And I can't perform a Vlookup or other action as Excel doesn't seem to recognise the data.
Is there a way to export from P6 into Excel and get a "normal", usable output?
Thanks very much
Dave
Printer-friendly version
Send to friend
There is very easy method over here
Hi
A nice plugin for excel is called ASAP Utilities which has a nice feature to remove those apostrophes in excel. There's a tutorial on updating activities through excel (with ASAP utils) over at https://www.planacademy.com/excellerate-your-updates-how-to-import-your-subcontractors-primavera-updates-from-excel/
Michael
Thanks very much guys.
Dave
David,
The ' character symbolizes left justify in excel. It comes in with some imports.
You could write a macro but the simplest way to remove ' character is to select a blank cell on the worksheet type the number 1 into it.
Ctl C this cell, highlight the column/ table, go to paste special and use the operation 'divide by'.
Problem solved, just note you'll need to re-format any date columns as the output will be numerical.
Also don't select the whole spreadsheet, it will return zeros for blank cells.
Regards,
Chris Hall
David,
Use the export through SDK....
Email: PPadmin@planningplanet.com
Replies