This project has moved. For the latest updates, please go here.

showing grid and format number using comma seperation in pivot table

Nov 5, 2014 at 6:27 PM
Hi,

I want to make pivot table where I can make visble the border for all the columns.
Also want to show numbers in comma seperated format.

Presently I am using format #,###.######

Which is causing issue like if the number is 10000 it displays it as 10,000. a dot after last zero

What I want to show is 10,000 and if number is 10000.50 it should be like 10,000.50.

Can someone please help on this. I am using Epplus version 3.1.2.
Nov 27, 2014 at 6:29 AM
Hi,

I want to make pivot table where I can make visible the border for all the columns.
Also want to show numbers in comma seperated format.

Presently I am using format #,###.######

Which is causing issue like if the number is 10000 it displays it as 10,000. a dot after last zero

What I want to show is 10,000 and if number is 10000.50 it should be like 10,000.50.

Can someone please Suggest on this. I am using Epplus version 3.1.2.