| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
