changing numeric value to text (in words)

  • Thread starter Thread starter gaurang
  • Start date Start date
G

gaurang

I have one cell having value $112.50 and I want to put the same in words
like One hundred twelve dollar and fifty cents in other cell.
Which formula shall I use to convert this?
 
Hi
I think this is at least the third time for today someone asks this
question :-))
So trying a Google search would lead to many links. Below a short list:

MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods
 
Back
Top