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? When you create a pivot table in Excel, the values displayed in the pivot tabl...
And then the field will become available for use in my Exel 2010 pivot table. I can--sort of--see the sense in this restriction--if I am correct about this. It keeps the underlying data schema--in the OLAP cube--in sync with the data schema in-use in the Excel 2010 pivot table....
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...
RegisterSign InExcelYour community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visit Microsoft Support Community.Forum Discussion Share ResourcesWhat's new Surface Pro 9 ...