| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
