Excel formula to convert number to words

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
a repost from public.excel:

-------

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


P.S: please don't multipost
 
I am a newbie to Excel.I want to know the following things.

1.Is there any inbuilt function to convert an amount in numerical format to
amount in words (for ex,1144.56 to Thousand one hundred and forty four
dollars and cents fifty six) ?

2.Is there any way of making the formulas in a excel worksheet permament
(formulas get deleted when you delete data)so that they can be used as a
template.

3.Is there any way of building custom functions for performing the above
mentioned tasks?

Regards,
Mukesh
 
Hi Frank,
thanx a lottt....it was very easy to use it in my
sheet.Can u pls guide me about the formula thing also...

2.Is there any way of making the formulas in a excel worksheet permament
(formulas get deleted when you delete data)so that they can be used as a
template.

regards,
Mukesh
 
Formulas only get deleted when you physically delete them -- not when you delete
the information that feeds into it.

If you have people that are wiping information out of an area with no regard as
to what the information truly is, enable worksheet protection and lock the
formula cells -- that way they will not be able to clear them


: Hi Frank,
: thanx a lottt....it was very easy to use it in my
: sheet.Can u pls guide me about the formula thing also...
:
: 2.Is there any way of making the formulas in a excel worksheet permament
: (formulas get deleted when you delete data)so that they can be used as a
: template.
:
: regards,
: Mukesh
: : > Hi
: > a repost from public.excel:
: >
: > -------
: >
: > 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
: >
: >
: > P.S: please don't multipost
: >
: > --
: > Regards
: > Frank Kabel
: > Frankfurt, Germany
: >
: > Mukesh Jain wrote:
: > > I am a newbie to Excel.I want to know the following things.
: > >
: > > 1.Is there any inbuilt function to convert an amount in numerical
: > > format to amount in words (for ex,1144.56 to Thousand one hundred and
: > > forty four dollars and cents fifty six) ?
: > >
: > > 2.Is there any way of making the formulas in a excel worksheet
: > > permament (formulas get deleted when you delete data)so that they can
: > > be used as a template.
: > >
: > > 3.Is there any way of building custom functions for performing the
: > > above mentioned tasks?
: > >
: > > Regards,
: > > Mukesh
: >
:
:
 
Back
Top