SRMPURCHASE
Board Regular
- Joined
- Dec 23, 2014
- Messages
- 210
- Office Version
- 2016
- Platform
- Windows
I have a total value in Values in a pivot table that can be divided in two areas, Statement in the column area.
One statement value is displayed in two digits and the other comes out with 13 digits.
This is random as far as I can tell, some values have 13 digits and a majority have 2 digits.
The data table is formatted to two decimal, pivot table field is two decimal.
How do I get all the values in that field to represent two decimals??
One statement value is displayed in two digits and the other comes out with 13 digits.
This is random as far as I can tell, some values have 13 digits and a majority have 2 digits.
The data table is formatted to two decimal, pivot table field is two decimal.
How do I get all the values in that field to represent two decimals??