Forum Discussion
Solved
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 ...
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 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.