Format Cells occasionally showing Chinese (Taiwan) locale

[cisco55]

Occasionally in Excel 2010 when I open Format Cells, I am presented with an odd result.
Does anyone have a good explanation? Is my Lenovo keyboard doing this?

 

[mole999]

I had polish zip codes added the other day after running some code across cells, i don't know the cause but if you can identify when it occurs in code you can at least reapply correct formatting over the top

 

[cisco55]

Thanks, I will be on the lookout and check manually while stepping through some VBA.

I've run a scheduled task .vbs to check the system locale, though I've never caught it with programmatic means.

locale = getlocale()
if locale <> 1033 then
msgbox "Locale changed to " & getlocale()
end if

I am reading these cells via VBA to populate a listbox on a userform.
It has occurred on this system several times now, using different workbooks and VBA.

 

[RoryA]

If a custom number format you apply happens to match one of the built-in regional ones, that's what you'll see displayed in the dialog. See this post for example: Excel Matters » Blog Archive » Custom number formats converting to Special formats

 

[mfexcel]

I am not sure if I have understood your question correctly... but why don't you select the "Locale" you need?