Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NUMSONLY function (Excel XP)

    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,

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: NUMSONLY function (Excel XP)

    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
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: NUMSONLY function (Excel XP)

    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.

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: NUMSONLY function (Excel XP)

    This may be something you've already done, but the easiet thing sometimes is to just try running it and see what happens. <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15> 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.
    <pre>x = NumsOnly("123 Woody Drive") ' x=123
    x = NumsOnly("abc98" 'x=98</pre>

    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 <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •