I'm using both of the fuctions to correct the european number format, but I
can't seem to get the syntax right.

What am I doing wrong?

Range("G" & x + 3).Activate
WorksheetFunction.REPLACE(G" & x &",Right("G" & x,1),1,"")
WorksheetFunction.Substitute(G & x,LEFT(G & x + 3),""-""&LEFT(G & x +
3),1)