converting numeric amounts into words

  • Thread starter Thread starter manish
  • Start date Start date
M

manish

i would urgently like to know whether there is any way to conver
numeric numbers like say ($ 5,400) into amount in words i.e. (Fiv
thaousand four hundred in either excel or Access
 
Hi
there're some macros/procedures to convert numbers to text. e.g.
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
 
You must log in or register to reply here.

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

Similar Threads

How do I convert numerical into words ? 3
convert number value to words of numerical value 4
HOW DO I CONVERT A NUMERIC IN WORDS? EG. 100 (ONE HUNDRED) 1
how to convert the numeric or amount in figure to word or inwords 2
How do I remove the last 4 characters within a cell 4
Convert numeric values in words. 6
how do I convert numbers to text eg 1 to one 1
how do i convert numbers in figures into words? 1

Back
Top