Changing text to number

  • Thread starter Thread starter DIAMONDGIRL
  • Start date Start date
D

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
 
Assuming only one of these, use Tools>AutoCorrect

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


Gord Dibben MS Excel MVP
 
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?
 
Back
Top