Run them through DataText to ColumnsFinish after making the
ToolsOptionsInternational changes.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 08:36:04 -0700, Nuno wrote:

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

"Fergal" escreveu:


Tools - Options - International

"Nuno" wrote:

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