![]() ![]() If you don't want to mess with macros then you can download and install the add-in to get this feature. I have also added this feature to The PivotPal Add-in. I've created a macro that automatically applies number formatting when you add a field to the values area. So, how can we change this default number formatting to something besides General? There are a few different ways to apply number formatting to the values area, and it can be time consuming process. This is a multi-step process that requires several clicks. As you can see in the screenshot below, the General format does not add commas/periods for thousands separators the number of decimal places is not fixed.Īfter adding a field to the values area, we then have to take extra steps to format the numbers. Unfortunately, the General number format makes numbers look UGLY. ![]() This is the default format for all cells on the worksheet, and the pivot table does NOT change it. Typically when we add a field to the values area of a pivot table, the cells are formatted with the General number format. The Problem with Pivot Table Number Formats The 2nd video that explains the macro is available below. The PivotPal Add-in (paid) also has this feature and can be downloaded and installed. Pivot-Table-Automatic-Number-Formatting-Macro.zip Download ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |