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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top