Changing text to number

[DIAMONDGIRL]

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

 

[Mike H]

Why does ANY.XX = 125.00?

 

[Gord Dibben]

Assuming only one of these, use Tools>AutoCorrect

If many, perhaps a VLOOKUP table will do the trick.


Gord Dibben MS Excel MVP

 

[DIAMONDGIRL]

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?

 

[David Biddulph]

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