Thread: NumberFormat
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RBeau RBeau is offline
external usenet poster
 
Posts: 10
Default 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.