A Good Afternoon to All,
I have a series of simple Excel 2010 pivot which I am using to lookup a value by userID and Date (the value for the same user varies over time). I have set the underlying table using round() to two decimal places. When I refresh the pivot, it appears to have two decimal places but when I use the pivot return from the lookup I am actually using a 13 decmial place number. This is creating havoc in my spreadsheet.
My question:
How can I set the pivot value not only to appear to be, but actually be, a two decimal number when used in calculations?
I thank you in advance.
I have a series of simple Excel 2010 pivot which I am using to lookup a value by userID and Date (the value for the same user varies over time). I have set the underlying table using round() to two decimal places. When I refresh the pivot, it appears to have two decimal places but when I use the pivot return from the lookup I am actually using a 13 decmial place number. This is creating havoc in my spreadsheet.
My question: How can I set the pivot value not only to appear to be, but actually be, a two decimal number when used in calculations?
I thank you in advance.
