Format Cells occasionally showing Chinese (Taiwan) locale

cisco55

New Member
Joined
Mar 8, 2014
Messages
9
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?

 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,109
Office Version
2019, 2016, 2013
Platform
Windows
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

New Member
Joined
Mar 8, 2014
Messages
9
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.

Code:
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.
 

mfexcel

Well-known Member
Joined
Jan 8, 2009
Messages
791
I am not sure if I have understood your question correctly... but why don't you select the "Locale" you need?
 

Watch MrExcel Video

Forum statistics

Threads
1,090,494
Messages
5,414,882
Members
403,550
Latest member
Haima1

This Week's Hot Topics

Top