View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pris Pris is offline
external usenet poster
 
Posts: 2
Default How to change the precision for Pivot Table

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!



--
Priscilla