Converting numbers to text

  • Thread starter Thread starter Scott Smith
  • Start date Start date
S

Scott Smith

Can I convert a value to the text for that value? For
example, "$4,808.96" to "Four thousand eight hundred and
eight and ninety six cents".
 
Hi
Try doing a Google search and you'll find many macros/procedures to
convert numbers to text. Below a short list for this topic:
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