SpellNumber

[Shakeel Ahmad]

I once asked for the formula that when i write figures in a cell these
should be converted to the words in other cells.

as 65841 = Sixty-Five Thousant, Eight Hundred and Forty-one

I have found (SpellNumber) to do this. But it can be done by making a module
in that file where this formula is needed.......

As in word, we can make macros or modules in the current document as well as
in Normal.dot, can we make this module in excel (normal.dot) that it should
work with all the files....

Thanks and Regards....
Shakeel Ahmad

 

[JLatham]

You could create a workbook with the SpellNumber code in it and use File |
Save As and save it as a template (.xlt) file. Then in the future when you
need to use it, you can create a new workbook from that template.

If you have one type of workbook that you often need that function in, you
can use it as the basis for the template file. When you create a new file
from it, it will start with the same sheets and appearance as the template
file, along with the functions built into it.

 

[Ron Coderre]

This might be an alternative for you....

I created a single-sheet Excel file that only uses a handful of Range Names
and Named Formulas to convert numbers to their spelled out values. No VBA
code at all.

Sample input/output:
Input Number 123.45
Translated Text: One Hundred Twenty Three Dollars and Forty Five Cents

If you're interested, just download the tiny (19 kb) file from this website:
http://www.savefile.com/files/872215

Once you have the file, just right-click on the DisplayForm sheet and copy
it into any workbook....there are no links to other files and no VBA code.

Does that help?

(Post back if you have any questions)
***********
Regards,
Ron

XL2002, WinXP

 

[Gord Dibben]

You could place the spellnumber code into your Personal.xls which would make it
available for all open workbooks.

See help on personal.xls for more info.

You also could place it in a module in a new workbook and save that workbook as
an Add-in under File Types.

I like the add-in because you can reference the function directly without adding
the Personal.xls! to it.

i.e. =SpellNumber(A1) rather than =Personal.xls!SpellNumber(A1)


Gord Dibben MS Excel MVP

 

[Nostalgie]

Bonsour® Shakeel Ahmad avec ferveur ;o))) vous nous disiez :

I once asked for the formula that when i write figures in a cell these
should be converted to the words in other cells.

as 65841 = Sixty-Five Thousant, Eight Hundred and Forty-one
Thanks and Regards....
Shakeel Ahmad

Have a look there :
http://xcell05.free.fr/english/morefunc/nbtext.htm

HTH