Number conversion

[Nuno]

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]

Tools - Options - International

 

[Nuno]

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

"Fergal" escreveu:

 

[Fergal]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP