| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i change pivot table to change data | Excel Discussion (Misc queries) | |||
| Decimal precision of change history? | Excel Discussion (Misc queries) | |||
| Worksheet change with pivot table | Excel Discussion (Misc queries) | |||
| Precision displayed does not match precision in cell | Excel Discussion (Misc queries) | |||
| Macro to change a Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
