Convert 1 688 090,69 to normal numeric value
=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
|