I figured it out.Basically I just replaced any reference on ',' with '.' and vice versa.And also changed the $ to the € symbol.Thanks for creating that formula!

Dear all, I've tried to figure out what everyone just seems to get from this but I can't..I'm trying to use . as thousand separator and , as decimal separator.So I'm trying to convert the numbers in my base from e.g 30,500.55 to 30.500,55.I use curre...