| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text to numeric
Hi,
I have the following text: "34.00 - 39.50". Is there a way to convert them into numerics format? Ex: 34.00 in B1 and 39.50 in C1, without typing? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text to numeric | Excel Discussion (Misc queries) | |||
| numeric value disply in text | Excel Discussion (Misc queries) | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Text to Numeric | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
