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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

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,507
Messages
5,414,961
Members
403,557
Latest member
hsstrider

This Week's Hot Topics

Top