number formating issue

[bartosz_s]

Hi to All,

I have a figure with decimal places which is displayed like this:
Before

I'd like to change this view to show it like it is but without decimal places. Unfortunatelly when I try to change Format and set decimal places to "0" thousand separator disapears. and have a figure:

Thank you,

B.

[Interkoubess]

Hi @bartosz_s,

Did you try the round function?

If not give sample data with expected results.

Ninter

[bartosz_s]

Hi,

unfortunately it doesn't work. ROUND function is not chanhing the way how the numbers are displayed (expected format is xxx yyy zzz. Example 123 456 789). I still have xxxyyyzzz.

Example:

Number: 123 456 789,89 is displayed 123456790 not 123 456 790.

[Interkoubess · Accepted solution]

hi @bartosz_s,

Then try this formula to create a calculated column ( my table is called Table1 and field Column1):

Column = FORMAT(Table1[Column1],"### ### ##0")

Hope it helps...

Ninter

[bartosz_s]

Thank you 🙂