ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   spellnumber function (https://www.excelbanter.com/excel-worksheet-functions/43882-spellnumber-function.html)

Imran

spellnumber function
 
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?


Ron Rosenfeld

On Mon, 5 Sep 2005 02:27:14 -0700, "Imran"
wrote:

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?


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

Paul Sheppard


Imran Wrote:
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?


Hi Imran

Details of how to create SPELLNUMBER can be found here

http://support.microsoft.com/default...23120121120120


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401886



All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com