You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025

Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers now only displays one currency symbol

I am from the UK but now living in Australia and so my finances involve both GBP and AUD values. My system us set up with Australia as region.


Prior to recent upgrade to Numbers version 4.1 (4328) I could set cells to display both £ and $ as appropriate for the values in the cells. Following the upgrade Numbers now displays GBP instead of £ for sterling cells which I am finding much harder to read quickly. $ is still displayed for Australian dollar cells.


Is there anyway to get the £ symbol back while retaining the $?

Posted on Apr 1, 2017 4:49 PM

Reply
Question marked as Top-ranking reply

Posted on Apr 2, 2017 3:07 AM

Note that you don't have to wait for Apple; you can easily achieve the effect you want simply by setting up a Custom Format. Under Data Format just choose 'Create Custom Format...' and set it up something like this:


User uploaded file


Thereafter it will appear in the Data Format dropdown like this:


User uploaded file


SG

6 replies
Question marked as Top-ranking reply

Apr 2, 2017 3:07 AM in response to datstheone

Note that you don't have to wait for Apple; you can easily achieve the effect you want simply by setting up a Custom Format. Under Data Format just choose 'Create Custom Format...' and set it up something like this:


User uploaded file


Thereafter it will appear in the Data Format dropdown like this:


User uploaded file


SG

Apr 1, 2017 10:47 PM in response to SGIII

Thanks for your suggestion.


Cells are all set correctly. However, since the upgrade when computer set to Australian region it now says "British Pound (GBP)" not "British Pound (£)". Other regions do still seem to offer £ with A$ for Australian dollar.


In Numbers "Language & Region" option to change region was greyed out on my spreadsheet. I think that this was locked by choice of "System English" as language, changing this to English allowed me to change the region to UK. A slight improvement as £ is back but now has AU$ as prefix for Australian dollars which, to me, makes it marginally easier to see the actual figure.


Seems like a conscious decision by Apple to change the way currencies are displayed in Australian region, only Australian dollars can be preceded by currency symbol, every other currency only offers the three letter code for the currency. I am sure there is a reason for it but can't think of one!


For my purpose I don't really need to format cells as currency so I will probably leave spreadsheet set to Australian region and just change all the sterling fields to be normal decimal numbers with two decimal places. Leaving Australian dollars as currency will have those displayed with $ to show the differences. At the moment I have difficulty picking out the actual values when written as GBP123.45 rather than £123.45 or AU$123.45 rather than $123.45.

Numbers now only displays one currency symbol

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.