pivot not showing number format with commas

olybobo · #1 05-05-2016, 01:39 PM

Hello experts;

I have a pivot table and I would like to show the number format with commas.
Hence, I would like the following for format
###,###,###

can this be done. Thanks

jeffreybrown · #2 05-05-2016, 05:09 PM

Have you tried to apply a custom number format to the column?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data not showing in Pivot Table	MichelPierre	Excel	2	01-26-2016 10:51 AM
Novice to Pivot Table: Need help to generate a report in a predefined format	Himansu	Excel	2	10-26-2014 03:57 PM
How to format a TOC (level 1) using a number, but have the number hidden in the text	porpoiseoil	Word	1	09-13-2014 12:53 PM
TOC showing both Heading1 and Page Number	FormatAdmin	Word	3	03-04-2014 01:20 PM
Change from General Format to number format	gbaker	Excel	3	08-16-2013 01:04 PM