R
RBeau
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.
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.