numeric to amount display

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Can you give me the codes for this problem. (prefereably
free). For Example I have 100 in cell A1. and I wanted to
display the word "ONE HUNDRED" IN CELL B1.
thanks
 
Bobby,
prefereably free
Click to expand...
Obviously, you are a newcomer to the newsgroups.
All of us here answer questions like yours because we enjoy doing so.
It's always for free. What is nice, but not necessary, is a "thank you"
posted
as a reply in the newsgroup thread if we have helped you.
For an introduction to the ng's, take a look here:
http://www.cpearson.com/excel/newposte.htm

Now in answer to your specific question, I'll paste a previous post by
Norman Harker below.

Welcome to the ng community.


From Norman:
<snip>
You should try a Google search for questions as you might imagine that this
is a fairly common question.

If you want numbers to be translated in Thai then there's an Excel function
BAHTTEXT that will do it. For some reason Microsoft didn
't think non-Thai speakers needed an equivalent. So, unless you want your
words in Thai:

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360

and:

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

and:

(courtesy of a cut and paste from a Tom Ogilvy post):

If you want an addin that provides a worksheet function that does this,
download Laurent Longre's free morefunc.xll addin found
here:

http://longre.free.fr/english/

It is downloaded in a zip file which also contains an informative file in
'hlp' format that describes the 33 or so very useful
functions included, one of which does the number to words conversion you
describe (supports various languages and currencies).

See also Laurent's latest version that is multi-lingual.

http://longre.free.fr/tradnombre/NbText.zip

and:
(Courtesy of Andy Wiggins FCCA) of www.BygSoftware.com

This file might be a help:
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 to convert numbers to words and two check writing
routines.

The code is open and commented.

And, finally:

http://groups.google.com/[email protected]

A post containing a UDF by Bernie Deitrick that will take you into US budget
territory by covering amounts into trillions.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel & Word format Function Lists free to good homes by direct request to:
(e-mail address removed)
 
Thank you very much for the tips. It was exactly what i
needed . I appreciate. I used the function and it works
perfectly but when I clode the file i am working on and
then open/create a new excel file then the function is
not available anymore. How can I use the function you
gave me and add it to the list of functions that are
provided by Excel? In other words, how can i make the
function you mention on the post available universlly and
therofre be able to use it like any other function
provided in Excel?

Thanks
Costas
 
Back
Top