| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a text word or text string to a number
Hi,
You are going to need to show us all the possible text entries. Otherwise there are an infinite number of possibiliities, for example "Zero" "None" "Seven Trillion Eight Hundred and Fifty Nine Million Six Hundred and Thirty Two Thousand One Hundred and Forty Nine and Twenty Three Cents" -- If this helps, please click the Yes button Cheers, Shane Devenshire "Tom" wrote: How can I convert a text word (i.e. None) to a number (i.e 0)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a range of Excel 2003 Cells to a Single text string | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Converting text string back into a formula | Excel Discussion (Misc queries) | |||
| Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
| Converting text string to a its proper time format | Excel Discussion (Misc queries) | |||
![Shane Devenshire[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
