By adding Ringstrom’s code, Excel users escape the frustration caused by manually formatting pivot table fields to add commas or remove decimal places – one field at a time. First, Ringstrom advises ...

This is because pivot tables in Microsoft Excel are designed to only show numbers in the “Values” section. If you add a text field there, Excel displays a count of those text items by default.