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 field. Excel format does not work, the only way to format a cell is to manually remove the apostrophe.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.