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.
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)
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)
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.
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>
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)