Convert 1 688 090,69 to normal numeric value
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 |
Convert 1 688 090,69 to normal numeric value
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 |
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 |
Convert 1 688 090,69 to normal numeric value
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 |
All times are GMT +1. The time now is 07:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com