| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting string to number
hi,
I have a set of data that is to be cut and pasted from an external source. A typical cell reads '32813.58 sq mm', without the speech marks. The cell could be formatted before the pasting; but how do I strip off the units to leave the number only? The number could be any size. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a text word or text string to a number | Excel Discussion (Misc queries) | |||
| Converting a string into a number format | Excel Discussion (Misc queries) | |||
| Converting string of letters to Number | Excel Discussion (Misc queries) | |||
| Extracting a number from a string and converting it into an Intege | Excel Worksheet Functions | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
Threaded Mode
