| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I separate numbers?
I have a web query which gives me the result "385/1700" and all I want is the
first part "385" to allow me to do calculations with, but because it's a web query, it wont let me just format it as a fraction and times it by 1700.. it comes up with the #VALUE! error. So I dont know what else to try, Can anyone help? Thanks, Aden |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separate numbers out of string | Excel Worksheet Functions | |||
| How can you separate a series of numbers into jenks? | Excel Worksheet Functions | |||
| How to separate the numbers and characters in the cell | Excel Worksheet Functions | |||
| How to separate numbers from text?? | Excel Discussion (Misc queries) | |||
| separate numbers that have a / between them | Excel Discussion (Misc queries) | |||
Threaded Mode
