NumberFormat

[RBeau]

I am working in Excel. I have a spreadsheet whereby when you click on a flag,
it changes data fields as well as changes currency. My method has worked well
in the past, but I am having a problem with Korean.

If I record a macro - 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.

 

[Paul Herber]

I am working in Excel. I have a spreadsheet whereby when you click on a flag,
it changes data fields as well as changes currency. My method has worked well
in the past, but I am having a problem with Korean.

If I record a macro - 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.

You need to ask in an Excel group, this one is for Visio.