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.
--
Priscilla


" wrote:

You could try this:

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

Hope this helps!!!


"Pris" wrote:

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