last digit of a number in Jira label is getting converted to 0 when exported to excel

Question

Hello, I have a number in Jira Label, I am trying to export the data to a excel and the last digit of the number is converted to "0" by itself.

Example: I have the number like 12345, when exported to excel I see the number is 12340 this is the first time I am experiencing this issue.

John Funk · Answer

Hi Sreejith - Welcome to the Atlassian Community!

Did you ever figure this out?

Tuncay Senturk _Snapbytes_ · Answer

Hi @Sreejith Gopinath

That's weird but what I'd check is to change the format of that column to text in Excel.