From the course: Excel: PivotTables in Depth
Join today to access over 24,600 courses taught by industry experts.
Change the data field number format
From the course: Excel: PivotTables in Depth
Change the data field number format
- [Instructor] When you create a PivotTable, Excel displays the values in the data fields without any formatting. When you look at numbers in the hundreds and below, the lack of commas doesn't really matter. But when you add those values in a subtotal or grand total, the lack of thousand separators makes the values harder for humans to read. In this movie, I will show you how to change the number format for the data values in your PivotTable. My sample file is 04_04 number format, and you can find it in the Chapter 4 folder of the Exercise Files collection. On sheet one of this workbook, I have a PivotTable, and the numbers don't have any formatting applied. They're just general. If I want to change the formatting of a PivotTable value field, then I need to right-click any cell within that field, and then, from the shortcut menu that appears, click Value Field Settings. So here I have Sum of Order Total, and I want to go to the bottom left corner and click the Number Format button. A…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.