User Profile
Gukai
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Why does excel data go from 2 decimals raw data to 7+ decimals when made into pivot table?
I have raw data that I frequently make pivot tables with. The numbers are like xxxx.xx, so always in 2 digits. When I take that raw data, it comes back as more than 2 digits, and I cannot figure out why. The pivoted data looks like this: The raw data looks like this: I'll even change the number formatting to see if there's something being masked by the formatting style... still 2 digits: So what is the pivot table doing to the raw data that is causing this?
