Skip to main content
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do i format all Columns of my table?


i want to create a table Extension to format and edit tables.

Within I want to change the number format of all columns in my Table.

For example: Every number is formatted like this:"12,5","100,5",... and I want to change the format to "12,50","100,50",...

I don't want to change it column by column, I want to change every column at once (e.g. 12 columns to change).

How can i do this? Do you have any suggestions or tips for me?

Thank you very much for the answer!

1 Reply


this is maybe a bit late and a too simple answer, but you can change the format of an Expression in a table simply by deselecting numformat (Zahlenformat) automatically (Automatisch) into user defined.

Then hhange the format to number (Zahl) in the drop down menue and pick a format of your choice.

This won't change the format of a dimension in the table, but when you additionaly put the same field as an Expression (Kennzahl) next to the dimension into the table, then you can adjust the numformat of the Expression row for the output view (see Screenshot)