Skip to main content
Planview Customer Success Center

Leading Zeros on a report while exporting to excel (2012)

QUESTION:
In version 12.01 when you export a report to excel, the alternate name field, project number, does not have the leading zeros .It is treated as a number column
In version 2012 when I export a report the leading zeros are there and the column is treated as a text column.
How does the export to excel treat the leading zeros on numeric/text format in a report?


ANSWER:
In General, a text field should not be treated as a number.
If users require it as a number field, they should use an advanced calculation in report designer that trims the leading zeros and/ or casts the field as numeric /int.