how do i use REPLACE to change 48.5M to 48,500,000?

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:

how do i use REPLACE to change 48.5M to 48,500,000?

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 EditPaste Special and check Multiply and OK.

HTH
Martin

The reply from last Wednesday didn't work?

Coco wrote:

how do i use REPLACE to change 48.5M to 48,500,000?

--

Dave Peterson