Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Custom Function: Convert Number To Words Returns #NAME!

  1. #1
    Join Date
    12th December 2006
    Posts
    3

    Custom Function: Convert Number To Words Returns #NAME!

    I tried to use the SpellNumber Custum Function in Excel 2007 given in MS Support site (KB 213360 ) to convert numbers to words, however I am getting error "#NAME?".

    What is going wrong. It used to work fine in Excel 2003, and The work book is in Excel 2003 Format.

    Convert a Numeric Value into English Words
    Convert a Currency or Value into English Words
    Last edited by Dave Hawley; September 19th, 2007 at 13:02.
    ________________
    Believe nothing merely because you have been told it. Do not believe what your teacher tells you merely out of respect for the teacher. But whatsoever, after due examination and analysis, you find to be kind, conducive to the good, the benefit, the welfare of all beings -- that doctrine believe and cling to, and take it as your guide.

  2. #2
    Join Date
    25th May 2004
    Location
    central Europe
    Posts
    773

    Re: Convert A Number To English Word In 2007

    assumeing the number to be spelled is in cell A1 and you want it to spelled in cell A2. In a2 you type =spellnumber(a1).
    this works nicely in xl 2003, macros need to be enabled, however, if I am not mistaken.
    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  3. #3
    Join Date
    12th December 2006
    Posts
    3

    Re: Convert A Number To English Word In 2007

    Yes you are correct, but the same function is not woking in Excel 2007! I wonder why.
    ________________
    Believe nothing merely because you have been told it. Do not believe what your teacher tells you merely out of respect for the teacher. But whatsoever, after due examination and analysis, you find to be kind, conducive to the good, the benefit, the welfare of all beings -- that doctrine believe and cling to, and take it as your guide.

  4. #4
    Join Date
    25th May 2004
    Location
    central Europe
    Posts
    773

    Re: Convert A Number To English Word In 2007

    well, who knows. Anyway, the attahced holds the function. If it does not work with you, maybe you want to step through the code to see where it fails.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    In formulae, depending on your locale, you might have to replace ; with , or vice versa.

  5. #5
    Join Date
    12th December 2006
    Posts
    3

    Re: Convert A Number To English Word In 2007

    The culprit was the fact that the Macros were not enabled. I had looked for this option earlier but could not find it in Tools>Options> in Excel 2007 (Old Excel 2003 Style).

    But when I opend your work-book Excel 2007 asked whether I want to enable macros and it worked.

    Thanx h1h.
    ________________
    Believe nothing merely because you have been told it. Do not believe what your teacher tells you merely out of respect for the teacher. But whatsoever, after due examination and analysis, you find to be kind, conducive to the good, the benefit, the welfare of all beings -- that doctrine believe and cling to, and take it as your guide.

  6. #6
    Join Date
    8th September 2005
    Posts
    224

    Re: Convert A Number To English Word In 2007

    The menu to set security options for Macros is Tools>Macros>Security.

    If it is set to high, then macros are automatically disabled without prompting the user.

    If set to medium, the user is prompted to enable or disable each time a workbook with Macros is opened.

    If set to Low, Excel automatically Enables all macros.

    MS Office defaults to security being set to High, so when you installed 2007 or upgraded, the setting was likely set to High, which caused your funtion to not work.
    I hope this helps.
    Check out theseTemplates & Calculators!

  7. #7
    Join Date
    24th June 2009
    Posts
    1

    Re: Custom Function: Convert Number To Words Returns #NAME!

    Well, I am using Excel 2007 and when I open the spreadsheet attached earlier in this thread, it works just fine.

    However, when I copy the code in the VB editor and insert it into a new module in my Personal workbook (so it will be available for all my workbooks), it does not work and I get a #NAME? error.

    My macro settings are to enable ALL macros and, indeed other macros work fine. Any idea what I am doing wrong here?

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    Re: Custom Function: Convert Number To Words Returns #NAME!

    Please do not take possession of someone else's topic. Did you also see that the last reply is already 3,5 years old. Not very current anymore.

    You can start your own topic if you want. Welcome to Ozgrid ;-)

    Wigi
    Regards,

    Wigi

    Excel MVP 2011-2014



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Custom Function Returns #NAME?
    By Kaisharga in forum EXCEL HELP
    Replies: 5
    Last Post: March 21st, 2008, 11:34
  2. Convert Nested Formula Into Custom Function
    By good4u in forum EXCEL HELP
    Replies: 4
    Last Post: January 31st, 2008, 18:17
  3. Function That Returns Row Number
    By Slims in forum EXCEL HELP
    Replies: 2
    Last Post: March 26th, 2007, 15:50
  4. Custom Function Returns Zero
    By dinom in forum EXCEL HELP
    Replies: 2
    Last Post: August 8th, 2006, 12:52
  5. Custom function returns range and comment
    By james4223 in forum EXCEL HELP
    Replies: 3
    Last Post: July 9th, 2006, 10:53

Bookmarks

Posting Permissions

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