View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Formula Convert Digits to Words (1000 write One thousand)

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Excel" wrote in message
...
I want to get the words for digits...eg. If I enter 4526 in a column , i

need
to get "four thousand five hundred twenty six" in another column
automatically.....
How can I do it? How make a formulae for this.