Export Wizard and field format

[MSP-addict]

When exporting to MS-Access you can choose the field type (char, num, date,
....) in the Wizard; for Excel this is not possible.

Result: exporting to Excel gives you for example a 'duration' column
containing the value '*** days'; I would prefer to obtain numeric values,
preferable in the chosen unit (hours or days).

Can this be done? If not: what other solution is / will be available?

 

[JulieS]

Hi MSP-addict,
One option is to insert a custom number field. Customize the field and
create a formula using the field [Duration]. That will show you the task
duration (in minutes) as a number. (You can modify the formula to convert
the minutes to days.) When exported to excel, the numeric value is exported.
Hope this helps. Let us know how you get along.
Julie