69 279,47
688 090,69
1 688 090,69

can anybody tell me what formula combination need I use to convert
above numbers into numeric values i.e

69,279.47
688,090.69
1,688,090.69

Thxs

In an adjacent column

=SUBSTITUTE(SUBSTITUTE(A1,",","")," ","")

and copy down.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
ups.com...
69 279,47
688 090,69
1 688 090,69

can anybody tell me what formula combination need I use to convert
above numbers into numeric values i.e

69,279.47
688,090.69
1,688,090.69

Thxs

=VALUE(SUBSTITUTE(SUBSTITUTE(A1," ",""),",","."))
and format the cells like #,##0.00

Regards,
Stefi


€� ezt Ã*rta:

69 279,47
688 090,69
1 688 090,69

can anybody tell me what formula combination need I use to convert
above numbers into numeric values i.e

69,279.47
688,090.69
1,688,090.69

Thxs

Hi

Format the column as general. Select the range with data, and replace all
"," with "." - the values a converted to numbers. Format the range to use
thousand separators.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



wrote in message
ups.com...
69 279,47
688 090,69
1 688 090,69

can anybody tell me what formula combination need I use to convert
above numbers into numeric values i.e

69,279.47
688,090.69
1,688,090.69

Thxs