REPLACE
 

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

REPLACE
 

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?

REPLACE
 

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

REPLACE
 

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