After exporting your project information to Excel, if you need to, you can change the data type of a field of information from text, for example, to numbers. For example, Duration fields are exported as text. You can easily change that text to numbers so you can run calculations on them.
In Excel, select the column heading and then click Format, Cells. Click the Number tab if necessary. Under Category, select General, Number, or Currency, as appropriate (see Figure 13-9). Set any number attributes you want and then click OK.
Even though the Task Mapping page of the Microsoft Project Export Wizard says they're Text fields, currency fields (such as Cost and Actual Cost) and earned value currency fields (such as BCWS and VAC) are automatically formatted as currency in Excel.
Was this article helpful?
What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.