How to Convert a Numeric Value into English Words

  • Thread starter Thread starter jc
  • Start date Start date
J

jc

Does any one know how to convert a numeric value into
english wordings in a excel worksheet...
 
jc said:
Does any one know how to convert a numeric value into
english wordings in a excel worksheet...

Hi jc
This is common question. Try doing a Google search and you'll find a
lot. Below a short list for this:
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

Frank
 
Back
Top