Announcement

Collapse
No announcement yet.

Custom Function: Convert Number To Words Returns #NAME!

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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, 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
    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.

    Comment


    • #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.

      Comment


      • #4
        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
        In formulae, depending on your locale, you might have to replace ; with , or vice versa.

        Comment


        • #5
          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.

          Comment


          • #6
            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!

            Comment


            • #7
              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?

              Comment


              • #8
                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.com ==> English articles ==> Excel memes

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

                Comment

                Working...
                X