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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to convert numeric to words Example 525 in words (Twenty five 2
How to I sum data from one sheet based off mulitple variables? 7
Function/Formula for Text Conversion 3
String to be split 4
Convert Number to Text for Index/Match 1
How can I convert digits to alpha text? 1
converting question; function, formula, or coding? 4
changing text to numerals 3

Back
Top