Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Oklahoma City, OK, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert Numbers to Words (2000)

    I found some code from the MSKB to convert currency numbers to english words (Q140704). However, I can't find how to make it work. It creates a function named Spell Number, but that function never shows up in my list of functions in excel. Can anyone offer any advice?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Convert Numbers to Words (2000)

    <P ID="edit" class=small>Edited by gwhitfield on 03-Sep-01 13:23.</P>Hyperlinked

    Hi,

    A brief reading of the MS article indicates that it is rather unclear as to how to install this Function. I think you will find that unless you install it into your "personal.xls", or install it into a workbook where you are going to use the function you will need to precede the function name with the worksheet name following the normal conventions (eg: "=personal.xls!spellnumber(A1)").

    The following article from Inside Microsoft Excel performs the same function, but gives some more explicit installation directions and examples:

    <A target="_blank" HREF=http://www.elementkjournals.com/ime/9710/ime97a1.htm>http://www.elementkjournals.com/ime/9710/ime97a1.htm</A>

    I hope this helps.

    Regards

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Convert Numbers to Words (2000)

    There is a free add-in which includes 33 functions including one which converts numbers to text.
    <A target="_blank" HREF=http://longre.free.fr/english/>http://longre.free.fr/english/</A>

Posting Permissions

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