Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do convert time into numeric | Excel Worksheet Functions | |||
How to convert numeric value to mins and addimg mins to Hrs. | Excel Worksheet Functions | |||
How do I convert text answers to numeric | Excel Discussion (Misc queries) | |||
how can I convert numeric number into text | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |