NUMSONLY function (Excel XP)

Topic

New Reply

The NUMSONLY function comes with the Analysis Toolpak. However, there doesn’t appear to be any help text associated with this function and a search on the MS TECHNET website didn’t turn anything up either. I am wondering if anyone here has used this function and can explain it in some detail.

Thanks,

Reply | Quote

Replies

Never heard of NUMSONLY, it gives a #NAME? error for me in XL2000 and XL2002. Are you sure that this isn’t one of your own functions? Perhaps in Personal.xls? –Sam

Reply | Quote

I had never heard of NUMSONLY either. It was presented to me as a function that comes with the Analysis Toolpak, but after I read your post I went to the MS Technet website and found a list of functions that do come with the Analysis Toolpak and NUMSONLY was not one of them.

There are a number of XLA files that are password protected that load with Excel in this corporate setting, so my guess is that one of them does have NUMSONLY as a User Defined Function.

Thanks for your reply.

Reply | Quote

This may be something you’ve already done, but the easiet thing sometimes is to just try running it and see what happens. It seems to me that you could try it in the debug window of the IDE and if it has any arguments the intelli-sense will display their type. From the name of the function my first guess is that it returns the numbers in a given string it is given.

x = NumsOnly("123 Woody Drive")        ' x=123
x = NumsOnly("abc98"                    'x=98

Also if the person who wrote the function was thorough, s/he should of written a function description visible in the User-Defined section of the Function list.

Deb

Reply | Quote