Skip to Content

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

Webi Decimal Formula (#,.00) Question


I use #0,.00 formula to get the decimal value for two digit after comma. But when I export report to Excel, it looks like 2943,00.

I want to see it like 2.943,00. I mean that I should see the point sign as well as comma.

How can I get 2.943,00 format when I export it to Excel?


Former Member
Former Member replied


you need to format as "#,###.00".The decimal point can´t be used to represent the decimal and thousand separator. And choose , on Web Intelligence Preferences at BI Launch PAD  the preference at

Select a priority for saving to MS Excel:
0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question