View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lotis Lotis is offline
external usenet poster
 
Posts: 1
Default How to change amount in figure to amount in words?

I want a formula on how to change/translate an amount in figure in a cell to
amount in words on the other cell within the excel sheet. How do I do this?

Like for example: In cell D3 I typed 6000, on cell D4 it should be " Six
thousand"

So I would have to type the words, instead it will automatically translate
the amount in figure to amount in words.

Thanks