spellnumber function

I

Imran

I received a file with the spell number function, but cannot use it in my
current excel program. Is it available only in provious version?
 
R

Ron Rosenfeld

I received a file with the spell number function, but cannot use it in my
current excel program. Is it available only in provious version?
Click to expand...

It was probably in a custom add-in that was on the original computer; and not
distributed with the file. I've not heard of such a function in any version of
Excel.

If you cannot find the original add-in, there are others on the web with
similar functionality that you could download and install. One is Longre's
morefunc.xll which is free and at http://xcell05.free.fr/

Of course, it uses a different function name (NBTEXT) and probably different
arguments, so you'd have to adapt your file or translate the arguments somehow
in VBA.


--ron
 
Top