I tried exporting using a standard map "Default Task Information" and I get the same result, all numeric fields are formatted as text but is such a way that they can not be reformatted in Excel short of taking extra steps such as the one Skip recommended above.
The export map specifies the...
Export to Excel worked ok for MSP 2007 but 2010 appears to export all data with an apostrophe as the first character so the fields are all text in Excel. This is a real problem for dates and numeric fields such as % Complete which can not be easily formatted in Excel when defined as a text...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.