| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
REPLACE formula
How can I use the the replace formula to change 48.7M to 48,700,000
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
REPLACE formula
Select the range
Edit|replace what: M with: E6 replace all Then format the cell to Number, 0 decimal places, and use 1000's separator. The edit|replace actually changes the value to a number in scientific notation. For example, if you enter: 3E4 =3*10^4 =3*10000 30,000 Coco wrote: How can I use the the replace formula to change 48.7M to 48,700,000 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formula to replace the #N/A value | Excel Worksheet Functions | |||
| Formula to Replace or eliminate any sheetname(s) in formula string | Excel Discussion (Misc queries) | |||
| replace formula | Excel Worksheet Functions | |||
| rounding a formula in a cell, then replace the formula | Excel Programming | |||
| rounding a formula in a cell, then replace the formula | Excel Programming | |||
Linear Mode
