Skip navigation
This discussion is archived

How to create a Macro

5509 Views 3 Replies Latest reply: Feb 25, 2009 12:57 PM by KOENIG Yvan RSS
Aung Level 1 Level 1 (0 points)
Currently Being Moderated
Feb 23, 2009 10:51 PM
Hi,
I am trying to create a new Macro in Numbers to automate number in words printing.
For example, if I enter 154.35 in a cell, I would like that macro to generate "One Hundred Fifty Four and Thirty Five cents".
I have that function in Excel but i would like to move to Numbers completely.
Any help on how to write that Macro?
MacBook Pro, Mac OS X (10.5.6), Have iWork 09
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Feb 24, 2009 9:41 AM (in response to Aung)
    There is no macro feature in Numbers.

    _Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
    Then, cross your fingers, and wait _at least_ for iWork'10

    I will edit my old script doing that so you will be able to use it in Numbers '09.

    Yvan KOENIG (from FRANCE mardi 24 février 2009 18:41:37)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Feb 25, 2009 12:57 PM (in response to Aung)
    The script is available on my iDisk:
    <http://idisk.me.com/koenigyvan-Public?view=web>

    Download:
    For_iWork:iWork '09:for_Numbers09:NombreEnLettres.zip

    It contains two versions.

    One translates anumber in letters using the French spelling.
    The other translates anumber in letters using the English spelling (at least, I hope that it's what it does).

    Yvan KOENIG (from FRANCE mercredi 25 février 2009 21:57:01)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.