I just paid for numbers latest version June 2012. iPad 3' v5.1.1. Want to format a cell as a currency not in the little list chosen by apple. Forums suggest using the custom format option but I can not see this anywhere? Any ideas how to add a custom format or how to extend the list of currencies to all currencies. If nothing else missing out a countries currency as too unimportant to include is just plain rude!
iPad, iOS 5.1.1
1) You posted to the Numbers on Mac OS X forum ( Apple Support Communities > iWork > Numbers > Discussions ). The iWork for iOS forum is more likely to provide the direct answer...
it is here: https://discussions.apple.com/community/app_store/iwork_for_ios
2) you can add custom formats (demonstrating from Numbers for Mac OS X) by opening the cells inspector:
Then naming the new format and setting the parameters of the format:
If the currency symbol is not in the list then you can preceed (or follow) the value with the proper symbol:
I decided to demonstrate this by showing a preceeding infinity sign before the amount:
Like I mentioned in the first response... this forum is generally for Numbers on Mac OS X so the people posting here may (or may not) have iWork on an iOS device. The forum link I provided is the iWork for iOS (which is the OS for th iPad).
I hope this helps.
Hi, thanks for reply.
Am confused as my screen says this is. Support/iWork/numbers discussion will check your link.
The options shown in your screen shots are not in the version of numbers I have for iPad
Regards
Paul
Hi Wayne
I'm using the OSX version to make a new currency too. Do you know is there a way to get it to format the new currency 'Accountancy Style' in cells? My new ones work fine from a calculation point of view but they look a little messy.
Hoping you can help!
Sorry to have bothered you, Wayne. Found a reply elsewhere that was useful:
Go to Numbers Preferences and check the box for "show complete list of currencies". Hopefully the one you want is on the longer list.
The one I was looking for was indeed there.
Adding a currency in numbers missing custom format option
