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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,097
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?
 

Forum statistics

Threads
1,089,169
Messages
5,406,585
Members
403,097
Latest member
danielcarrington

This Week's Hot Topics

Top