Format value currency without decimal (M in Excel side)

[nicolas.talvasson@ouestco]

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

I try currency but it rest decimal


Thanks
Nicolas

 

[p45cal]

1223445,45

What is the comma about in this 'value'? I have no idea what this represents.
Perhaps write it out without commas and use a full stop (period in the US) as a decimal point.

You can get the 1 234 with custom formatting of # ###



Maybe extend the custom formatting to ### ### ###

 

[nicolas.talvasson@ouestco]

Hi
Thanks for you reply
The comma is the separation for the decimal

How do i do your formating in M language, i didn't want to do it in excel, but in m in power query in excel

 

[p45cal]

try:

= Number.ToText(1223445.45,"n0","fr-FR")

 

[nicolas.talvasson@ouestco]

try:

= Number.ToText(1223445.45,"n0","fr-FR")

View attachment 11144

Yes thanks a lot
= Table.AddColumn(#"Longueur du texte insérée", "Colonne2", each Number.ToText([Colonne1],"n0"))
Have a nice We
Nicolas (From France)