Skip to main content
M
MICHAELCR
Level 2
October 4, 2019
Question

excel exports text not numbers

  • October 4, 2019
  • 1 reply
  • 409 views
Has anybody addressed the issue that excel exports from views (such as the resource planning view) provides most of the data points as text fields, which then need to be converted to numbers? Michael Crocken, PMP, MS Mech. Engr. Senior Team Leader, Project Management Whole Foods Market Austin, TX
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

D
DavidCo3
Level 10
October 4, 2019
Hi @Michael Crocken . If you go into text mode, you can change the format of the fields to be numbers only (i.e. without the 'hours' word) and in Excel you will see it as a number format. The below example is for the Planned Hours field: aggregator.displayformat=minutesAsHoursString aggregator.function=SUM aggregator.namekey=plannedhour.plural.abbr aggregator.valuefield=workRequired aggregator.valueformat=compound displayname=Planned Hours linkedname=direct namekey=work querysort=work textmode=true valuefield=work valueformat=doubleAsDouble David Cornwell
Terms & ConditionsAccessibility statement

Loading footer...