Transform 12,50 in 12.50

Originally Posted by mdw

another way would be to clean up the data first
use text to colums delimited with euro symbol as delimiter
then find replace , with .

I would say that the earlier point regards replacing "," with nothing first holds true irrespective of approach unless values are always < 1000

1.005,50

would otherwise become

1.005.50

and would still not be a valid numeric entry.

Replace "." with nothing and then replace "," with "."