Pivot Table Bins

Copper Contributor

Hi there! I am trying to create a pivot table, but it will not label the bin "0." It instead labels it 6.9389E-18.  You can see it in the Pivot Table below in the third bin. How do I make this read as "0" instead?

 

Thank you for your help!

 

excel.png

1 Reply
Technically it is probably not 0... but really really small. Try putting a number format on the pivot table cells (with maybe 4 decimal places) ? Alternatively in your source data, use a vlookup to a name/grouping via the amount, then use that in the pivot table