How to format numbers in a pivot table

Let’s take a look.

There are two ways you’ve got the option to format values in a pivot table.

The first way is to select cells directly in the pivot table and apply a format manually.

Let’s undo this format, and look for a better way to apply number formats.

A much better way to set number formatting is to apply it to the field itself.

you’re able to do this in three ways.

The first way is to smack the field drop-down menu, and choose Value field parameters.

Note, however, this only works when you don’t have column labels in your pivot table.