Forum Discussion
Valuta decimal separator changing from comma to point
Hi, I want to change the local decimal separator voor Valuta in our dutch version being changed from comma to a point. I tried to do it by change the reginonal settings to English (VS) and to ma...
It finally worked.
I'd used the following formula:
EnglishFormat = SUBSTITUTE(FORMAT('Table'[Collumn], "#####0.00") ,",",".")
This makes the dutch format to English now. so the separator is changed from comma to point .
Thanx for you help 🙂
Jimmy801
Community Champion
Community ChampionHello Anonymous
what I meant is that I can't see that column on the screenshot. And I'm asking myself if this column maybe is already formated as text.
Because the format-function is for sure the function to use, and it works as I proposed.
Jimmy
It finally worked.
I'd used the following formula:
EnglishFormat = SUBSTITUTE(FORMAT('Table'[Collumn], "#####0.00") ,",",".")
This makes the dutch format to English now. so the separator is changed from comma to point .
Thanx for you help 🙂