View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Formula Convert Digits to Words (1000 write One thousand)

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;Q213360&;

and:

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...EN-US;q140704&

--
Gary''s Student


"Excel" wrote:

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.