I have a workbook that is distributed to users located in different countries of the world. On this workbook, I have a drop down where the user can select the country and currency e.g Japan (USD), Japan (JPY), China (USD) and so on. Based on this input, a macro formats some ranges with the currency symbol specified in the drop down e.g $ for USD and ¥ for JPY. The code that I'm using is:
With Worksheets("MYSHEET").Range("ABC1to5_CURRENCY")
.NumberFormat = "$ #,##0;[Red]$#,##0"
End With
Now the issue is that this code changes when run on a computer with different language settings. For instance, it shows ¥ instead of $ on Japanese version of Windows OS. Also the code ALT+0165 does not yield the same result of YEN symbol in the Japanese version. Can anyone please tell me how to hardcode these currency symbols so that they display the same across all computers?
Thanks!