View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DIAMONDGIRL DIAMONDGIRL is offline
external usenet poster
 
Posts: 4
Default 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