View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default changing text to numerals

What is the "range" of the the text i.e. is it simply "one"," two ","three"
or [for example) "one hundred and tweny four"?

"JRD" wrote:

Is there a quick and easy way of changing numbers enter as text (i.e. one,
two, three) to numerals. I have a whole column of numbers entered in text
form that I need to convert!

Thanks