Forum Discussion
Valuta decimal separator changing from comma to point
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 🙂
So,
When i try this i got an message of "to much arguments for function 'SUM'
Then i'd made a few adjustments butr very time there is a unwanted result.
Hello Anonymous
witch column are you referencing?
Could this column already be formated as text?
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 🙂
Hi Jimmy,
Tje collumn im reffering to is called "gedeclareerd"
This collum can't be reformated as tekst in the model setting.
Hello 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
Hello
i would appreciate if you could mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
Jimmy