Cannot Customize currency in Numbers 3.1

Question

Cannot Customize currency in Numbers 3.1

I need to issue invoice in AUE Dirhams....

However this currency AED of "Dhs." is not listed amond the currencies available in inspector for the currency

Is there any way to customize list of available currencies?

MacBook Pro (Retina, 13-inch, Late 2013), OS X Mavericks (10.9.1), iWork Numbers 3.1

Posted on Feb 17, 2014 5:23 AM

Reply

Answer 1

Feb 17, 2014 10:00 PM in response to Mikhail Goncharov

http://en.wikipedia.org/wiki/United_Arab_Emirates_dirham

Google and Wikipedia tell me that AED is United Arab Emirates Dirham. Have you tried changing the region of the OS to United Arab Emirates?

Or, maybe you can just concatenate the number to the symbol? Use & to concatenate the number to the text.

= 12&"د.إ"

12د.إ

or maybe =12 AED works?

I am not sure if the symbol goes in the front or back. Of course, you'd have to do the calculations with the number before concatenating the text. You could put the real calculations with numbers in a hidden column and just display the results concatenated with the symbol.

Reply