| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing text to number
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing text to number
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing text to number
Assuming only one of these, use ToolsAutoCorrect
If many, perhaps a VLOOKUP table will do the trick. Gord Dibben MS Excel MVP On Thu, 6 Nov 2008 12:06:01 -0800, 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 |
|
#4
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing text to number
If a letter is in A2, =CODE(A2)-64 will give 1, 2, 3, etc. from A, B, C,
etc. It isn't clear how you have combined the results from ANY.XX to give 125.00, as the letters A, N, Y, X, X respectively would be 1, 14, 25, 24, 24 -- David Biddulph "DIAMONDGIRL" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
