| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimal to comma
how do i convert a set of numbers represented in non-US format, n.nnn.nnn, to
US format n,nnn,nnn? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
decimal to comma
On the surface this seems like a routine formatting issue. Is there
more to the problem than that, perhaps a datafile that's hardcoded in the non-US format? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
decimal to comma
Use Edit-Replace to replace all decimals with nothing (leave replace blank)
and hit replace all. Then change the format to add the commas in. "George P" wrote: how do i convert a set of numbers represented in non-US format, n.nnn.nnn, to US format n,nnn,nnn? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I get a comma instead of a decimal why ? | Excel Discussion (Misc queries) | |||
| Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
| Using macro for decimal decrease or a utility ? | Excel Discussion (Misc queries) | |||
| Word destrots the comma as decimal divider in Excel | Excel Discussion (Misc queries) | |||
| Change Dots into Commas as Decimal Divider | Excel Discussion (Misc queries) | |||
Linear Mode
