SpellNumber
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.
"Shakeel Ahmad" wrote:
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
|