Benches Uncategorized

4

How to create a Macro

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

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?

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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)

  2. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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)

  3. 0

    Aung

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Great! You have a script? So, can you please share your script? I will also find out how to write the script. Thank you for the answer.

  4. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    The script is available on my iDisk:

    <http://idisk.me.com/koenigyvan-Public?view=web&gt;

    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)