Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
.numberformat Q | Excel Worksheet Functions | |||
NumberFormat | Excel Discussion (Misc queries) | |||
numberformat? | Excel Discussion (Misc queries) | |||
NumberFormat? | Excel Worksheet Functions | |||
Numberformat | Excel Programming |