Forum Discussion
Currency vs Accounting for euro, pounds, and dollars
I applied both currency and accounting formats to the same numbers for three different currencies: euro, ponds, and dollars. Here is the result:
As you can see, the position of euro symbol is different in accounting with respect dollars and pounds. Any idea why and how to fix that? I also want to be able to specify if symbol should be a prefix rather than a suffix without creating a custom format, so that I can easily apply it by clicking on an icon. But how?
True. Sorry about that; I use scientific more often than currency.
From what I see, though, accounting settings also allow the placement of the Euro sign to be changed. Perhaps not at the click of a button though.
5 Replies
If you go to format number, currency, symbol, you do get a choice of position for the Euro sign.
PeterBartholomew1 That's in CURRENCY, not ACCOUNTING. I need to do that for accounting format.
True. Sorry about that; I use scientific more often than currency.
From what I see, though, accounting settings also allow the placement of the Euro sign to be changed. Perhaps not at the click of a button though.
Create a workbook template with specific currency formatting settings
The easiest way, in my humble opinion, is still custom formatting:
left: € ##. ## 0; - € #. ## 0
right: ##. ## € 0; - #. ## € 0
or as an alternative with VBA:
Private Sub currency_Change() If currency = Chr(128) Then Range("A10:E140") = 0 ActiveSheet.Range("A10:E140").NumberFormat = "#,##0 $" ElseIf currency = Chr(36) Then Range("A10:E140") = 0 ActiveSheet.Range("A10:E140").NumberFormat = "#,##0 [$$-409]" End If End SubI would be happy to know if I could help.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
