I have a spread sheet from europe and they format numbers by using the decimal first then comma ..... i.e. the number 22,222.22 comes from them as 22.222,22 ... my question is how do i convert the whole column back to the comma first then decimal .. i have tried highlighting the colum and going to comma but it does not work.