Zoho Pivot - Column Formatting Problem
I have data that looks something like the table below. If I format it with decimal places, figures like 104,292 turn to 104,292.00, and I don't want that as readability suffers. I don't want to remove the decimals either because they're important for that variable.
How would I format this data so it can look like my expected values?
Expected:
Value | Column1 | Column2 |
A | 104,292 | 302,488 |
B | 1.24 | 3.32 |
C | 112 | 309 |
Actual Zoho Pivot:
| Value | Column1 | Column2 |
| A | 104,292.00 | 302,488.00 |
| B | 1.24 | 3.32 |
| C | 112.00 | 309.00
|