Forcing US Currency (or other country) in Cell

Question

I'm hoping this is an easy one. I'm using Range.NumberFormat = "$#,##0.00" to format a cell as US currency. But when our users in Japan open the workbook, they see it in Yen ¥ instead. I'm assuming because windows knows they are regionalized to Japan. Is there a way to force it to stay US so there isn't any confusion?

Thank you

"USD #,##0.00"? just an idea. – Rosetta Dec 20 '19 at 19:25 — Rosetta, Dec 20 '19 at 19:25
Thanks, but this just throws an error – Jason Brady Dec 20 '19 at 19:41 — Jason Brady, Dec 20 '19 at 19:41

BigBen · Answer 1 · 2019-12-20T19:36:14.317

1

I am unable to test this in a different region, but try:

Range.NumberFormat = "[$$-409]#,##0.00"

based on the locale code [$-409].

Another version:

Range.NumberFormat = "[$$-en-US]#,##0.00"

edited Dec 20 '19 at 19:36

answered Dec 20 '19 at 19:34

BigBen

46,229
7
24
40

Its already their weekend, so I'll have to wait until Monday (US) time to see if it works, but thank you. – Jason Brady Dec 20 '19 at 19:36

Forcing US Currency (or other country) in Cell

1 Answers1