Formatting of field (price) when exporting to Excel

Question

Good day,

We have an Issue with a Custom Field called Price and it was created as Type Number Field.

In the Issue the value is: 1,455,635.04

When we export the report to Excel the value in the cell is given as 1.45563504e+06

Can we configure the export functionality in Jira to make the Excel file useful?

Thanks!

Esraa Mahmoud · Answer

Hi @Jacques B For existing issues you can copy the existing values to a new text type custom field and then export would be possible.

If you are interested in doing that and you think it might work below are a couple of links that can help you with the procedure:

* Importing data from CSV: Updating existing issues.
* Megan's comment in THIS community post explains the procedure in details.

Hope that helps :)

Jacques B · Answer

Thanks @Esraa Mahmoud Atlassian support made a similar suggestion. Thing is we have many Issue that already use the existing numeric field, which I would like to be able to export.

Esraa Mahmoud · Answer

Hi @Jacques B I am not sure what is the full use case however would it be possible to use a text field type instead of a number field which will result in exporting the field content as it is without any modifications in format.