C
Coco
how do i use REPLACE to change 48.5M to 48,500,000?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefi
Say 48.5M is in A1, then
=VALUE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"M","00000"))
and format the result cell like
# ##0
(supposed that your Thousands separator is set to comma)
Regards,
Stefi
„Coco†ezt Ãrta:
=VALUE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"M","00000"))
and format the result cell like
# ##0
(supposed that your Thousands separator is set to comma)
Regards,
Stefi
„Coco†ezt Ãrta:
M
MartinW
Hi Coco,
Another way is to select all your data and do a find M
and replace with nothing, then type 1,000,000 into an
empty cell, copy it, then select all your data again and
goto Edit>Paste Special and check Multiply and OK.
HTH
Martin
Another way is to select all your data and do a find M
and replace with nothing, then type 1,000,000 into an
empty cell, copy it, then select all your data again and
goto Edit>Paste Special and check Multiply and OK.
HTH
Martin
D
Dave Peterson
The reply from last Wednesday didn't work?
how do i use REPLACE to change 48.5M to 48,500,000?