NumberFormat
I have a spreadsheet whereby when you click on a symbol, it changes data
fields as well as changes currency. My method has worked well in the past for
several languages (French, German, Spanish, etc.), but I am having a problem
with Korean.
If I manually change format - select a cell, go to format, change currency to
Korean, it works fine - formats correctly - ‚©5,000.
However, if I take that same code and place in a macro, I get ?5000 instead.
The code I am using is: Selection.NumberFormat = "[$?-412]#,##0"
Is there are reason that the results would be different?
Thanks in advance for any advice or suggestions you may have.
|