Number formatting wrt UK standards

[harshagraj]

Hello all,

Please help me to format these numbers 1,17,61,066.71 ->>>>1.17.61.066,71; 11,761,066.71 ->>>>11.761.066,71.

Thanks in advance.
@Greg_Deckler 

[harshagraj]

Hi thanks for the answer but unfortunately it doesnt work.

[jppv20 · Accepted solution]

Maybe one of the answers here can help you:

https://community.powerbi.com/t5/Power-Query/Data-Cleaning-Converting-from-European-to-US-UK-Number-...

Or you can check out this blog:

http://schoennie.blogspot.com/2018/11/thousand-separator-and-decimal.html

[jppv20]

Hi @harshagraj ,

This should work:

Go to transform data --> replace values:

Replace , with blank

Replace . with ,

Change format to number

Close & Apply

Select the column & in column tools you can select the thousand separator.

If I answered your question, please mark it as a solution to help other members find it more quickly.