| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing text to number
The code is set up where a letter represents a number. For example: A=1,
B=2, C=3, and so on. How do I convert the text to its equilvilant number? "Mike H" wrote: Why does ANY.XX = 125.00? "DIAMONDGIRL" wrote: I have a text code that I want to change to the numeric equilvilant. For example my code reads: ANY.XX and I want to convert it to read 125.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Import Wizard - Changing number format | Excel Discussion (Misc queries) | |||
| copying a cell and changing the formating from number to text | Excel Discussion (Misc queries) | |||
| How to keep "text" number from changing to date.... | New Users to Excel | |||
| edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
| Changing cell or text color depending on week number | Excel Discussion (Misc queries) | |||
Threaded Mode
