tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
Can someone please explain why the following "looks correct" on my version of Excel 2019:
but doesn't on others?
I see the euro sign but others see a vertical line for the currency.
Instead, they have to write this:
Thanks
Code:
Selection.NumberFormat = _
"_-[$€-x-euro2] * #,##0.00_-;-[$€-x-euro2] * #,##0.00_-;_-[$€-x-euro2] * ""-""??_-;_-@_-"
but doesn't on others?
I see the euro sign but others see a vertical line for the currency.
Instead, they have to write this:
Code:
Selection.NumberFormat = _
"_([$ˆ-x-euro2] * #,##0.00_);_([$ˆ-x-euro2] * (#,##0.00);_([$ˆ-x-euro2] * ""-""??_);_(@_)"
Thanks