Forum Discussion
Pivot Table Bins
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!
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
