How to change the precision for Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have problem to have 12 decimals places in Pivot table.

e.g if the computation result is 10.123456789012, Pivot table will give the
same 10.123456789012. But if the computation result is 1234567.123456789012,
because of the precison is up to 16 (if I am not wrong), Pivot will display
the result as 1234567.12345679. It will truncate a few decimals places. Is
there anyway to solve this because the result I want is 1234567.123456789012.
Thanks!
 
You could try this:

Change the format to (CUSTOM)
#.####################

Hope this helps!!!
 
I have tried chaging the format to "#.####################". However, it
doesnt work, the results after computed by Pivot table will have less decimal
places. can help me think of other solutions? Thanks a lot.
 
Dear Pris,

Try this:

Right Click on the Pivot Table
Select Pivot Wizard
Layout
DATA-Double Click
Select Number
Select Custom
Type: #.####################### (23 characters for buffer)

Click OK.

If it is Value (not text), it should work.

Hope this helps!!
 
Dear Pris, I can send you a simulation of what you have posted if you want to.

You can drop me a line to (e-mail address removed)

Thanks.
 
Back
Top