Solved: Format value currency without decimal (Excel side ...

nicolast29 · ‎10-08-2022

Hi

I have value in a column, i didn't arrive to format it like this :

Ex Value :

1234.45 => 1 234

1223445,45 => 1 223 45

A space between block and whitout decimal

Thanks

Nicolas

ImkeF · ‎10-08-2022

Hi @nicolast29
you have to apply this as custom format string in the model properties like so: # ##0

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

ImkeF · ‎10-09-2022

Hi @nicolast29 ,
this should work as a custom format string in Excel as well.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

ImkeF · ‎10-08-2022

Hi @nicolast29
you have to apply this as custom format string in the model properties like so: # ##0

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

nicolast29 · ‎10-09-2022

Sorry after slipping i forgot to say in Excel and not in Power BI

Format value currency without decimal (Excel side not Power Bi)