Data column number formatting in Excel
Can I overwrite the formating for the data columns in excel?
For calculation purposes I need 2 decimal places defined for the data columns but when I display I dont want to see the decimals, I want to see the rounded number. But I cannot format this on the excel. Any suggestions?
Dries Paesmans replied
In the definition of your planquery, go to the properties of your key figure and assign the number of desired figures behind the comma.
-> in your workbook if you click on your cell, you will see the number of figures behind the comma according to your info-object in the formula bar, but in the layout itself it is rounded according to your query settings