Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?



Former Member
Former Member 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


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question