Currency vs Accounting for euro, pounds, and dollars

[Dario_de_Judicibus]

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?

[#2]

@Dario_de_Judicibus 

Format numbers as currency

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 Sub

I 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.

[#3]

@Dario_de_Judicibus 

If you go to format number, currency, symbol, you do get a choice of position for the Euro sign.

[#4]

@Peter Bartholomew That's in CURRENCY, not ACCOUNTING. I need to do that for accounting format.

[#5 · Accepted solution]

@Dario_de_Judicibus 

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.

[#6]

Wow... you got it. Thank you very much. Now the ideal would be to associate (€ 123) to the € button in the top bar, but you gave me a good hint.