Quick question: I have a pivot table that is showing the grand total as Zero but if you click on the cell you get -2.0463630789E-12. I have used the round function to ensure that there are not more than 2 decimal places. However everytime I refresh my pivot it's still showing scientific data. Any help would be appreciated.
Difficult to say without seeing the request in context. Please upload the workbook.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks