Convert numbers into its equivalent in words?(12 to Twelve)
 

Is there any function that allows me to convert number into their equivelent
in words? Please advise

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AAMC" wrote in message
...
Is there any function that allows me to convert number into their
equivelent
in words? Please advise

This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"AAMC" wrote in message
...
Is there any function that allows me to convert number into their
equivelent
in words? Please advise