Converting numbers into words

[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

 

[Frank Kabel]

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

 

[Bob Phillips]

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)