Number conversion

Nuno · May 6, 2008

hi!
Can anyone tell how do I convert this number format 2,345,444.98 to this one
2.345.444,98?

Thank you a lot

Fergal · May 6, 2008

Tools - Options - International

Nuno · May 6, 2008

it doesnt work, because i've paste the number on the excel and i want to
convert the numbers allready pasted!

"Fergal" escreveu:

Fergal · May 6, 2008

Select Col - edit - replace "," with "x", "." with "," & "x" with "."

Gord Dibben · May 6, 2008

Run them through Data>Text to Columns>Finish after making the
Tools>Options>International changes.

Gord Dibben MS Excel MVP