Converting numbers into words

  • Thread starter Thread starter Sathish
  • Start date Start date
S

Sathish

hoe to convert a numaric in to words

Eg
100 to be converted to One Hundred

152963 to be converted to one hundred and fifty two
thousend nine hundred and sixty three
 
Hi
this is common question. Try doing a Google search and you'll find a
lot macros, etc.. 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
 
Sathish,

Google throws up hundreds of solutions, but Laurent Longre's MOREFUNC.XLL ,
available at http://longre.free.fr/english/index.html has a Numbers to Words
Function
along with many other useful Functions.



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top