Convert decimal character in number

Cut the "." and replace "," with "." :-)

And if you really want it to be converted from:

Danish: 80.567,00
American: 80,567.00

You can start replace . with #
Then replace , with .
And last: # with ,

Then you should have the format you want.

If you can skip the thousand separator, you do a direct conversion:

? Str(CCur("80.567,80"))
80567.8

I can skip the thousand separator, but I can't skip the decimals. In all the suggested solutions to my question I loose the decimals in cases ",00" -> "" and ",80" -> ",8" and that's not so good.

Why is it a problem that ,80 turns into ,8?

The value is the same in the end

Hi  jakobdo

I agree  that it is the same.
We are in a situation that data must be manually typed into another system and then the visual layout is important to speed up the proces and minimize mistakes.
I accept your solution and add "0" in cases where lost and accept character format.
OMN