For some reason, whenever I export a report with the count of tickets, it comes with lots of unsolicited zeros.
I have tried to format the numbers in all ways possible to remove it but didn't find a solution, only manually checking the right information on Zendesk so I can then remove the correct amount of digits.
Did you export that file via Zendesk Explore? If yes, I recommend checking the CSV export decimal precision in Zendesk Explore and setting it to the desired number of zeroes you want in the exported file - Setting export separators and decimal precision.