Problem with Currency Symbol

Question

Level 1

9 points

Problem with Currency Symbol

Is there a way to customise the currency symbol in El Capitan? My Language & Region setting is as follow. Before upgrading to El Capitan, currency in application, such as Excel, is shown as "$". After the upgrade, it is now shown as "HK$". I prefer showing it as "$". But if I change the Currency to US Dollar ($), the symbol will become "US$".

This problem has been bugging me for a while. I know I can use custom format for currency in the software, such as Number or Excel. However, I cannot change the format in some software, such as MYOB. The Income Statement is now filled with HK$, which is indeed very difficult to read. It also creates other problem. For instance, if I copy a cell with HK$ in Excel to Google Sheet, it will be treated as TEXT in Google Sheet instead of number. I therefore need to change the format in Excel to plain number first before I do the copy and paste. This doesn't happen to Mountain Lion or prior versions. Any idea if I can customise the currency symbol in the OS? Thanks!

Posted on Feb 14, 2016 7:13 PM

Reply

Answer 1

Feb 14, 2016 7:17 PM in response to Lindberg

In system preferences under keyboard > text

You could add replace text so every time you type a certain symbol it automatically replaces with the one you want.

Reply

Answer 2

Király

Level 6

10,017 points

Feb 14, 2016 9:38 PM in response to Lindberg

Submit an enhancement request to Apple, requesting a setting to choose a custom currency symbol. In the meantime, in Language & Region, if you change the currency to Canadian Dollar do you get just "$" where you want it? Or do you get "CA$"?

Reply

Answer 3

Lindberg Author

Level 1

9 points

Feb 14, 2016 10:07 PM in response to Király

Canadian Dollar will give me "CA$". Just curious, does this happen to you too? In a MYOB forum, I see people querying about the additional US, CA, or HK in front of the $ sign after the OS upgrade. But I'm surprise not too many people are talking about this.

I will submit a request. Thanks.

Reply

Answer 4

sberman

Level 10

268,251 points

Feb 14, 2016 11:01 PM in response to Lindberg

The screen shot you present is obtained from System Preferences > Language & Region > Advanced.

The way the currency is presented depends on the Region you set at the screen before that one: System Preferences > Language & Region.

Reply

Answer 5

Lindberg Author

Level 1

9 points

Feb 15, 2016 12:14 AM in response to sberman

I see what you mean. When I set the Region to Hong Kong and US Dollar under Advance, the symbol will show "US$". But if I set the region to US (or Canada), it will show "$" only. So, unless I can change the region to US (or Canada), I will have the problem trying to show "$" only. I guess it doesn't hurt changing the region to US, does it?

Thanks.

Reply

Answer 6

sberman

Level 10

268,251 points

Feb 15, 2016 1:59 PM in response to Lindberg

I would think you could also show "$" only using this method:

Set the region to Hong Kong and use Hong Kong dollars under "Advanced".

If that does not work, then scroll through the list of advanced dollars to see if one appears without a prefix in parentheses (like "US").

Reply