| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number conversion
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number conversion
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number conversion
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number conversion
Select Col - edit - replace "," with "x", "." with "," & "x" with "." "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number conversion
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Conversion | Excel Worksheet Functions | |||
| Number conversion to Hours | Excel Worksheet Functions | |||
| Number Conversion | Excel Discussion (Misc queries) | |||
| Number Conversion | Excel Discussion (Misc queries) | |||
| Number conversion | Excel Discussion (Misc queries) | |||
Linear Mode
