This is an undesirable aspect of the Asian
languages compatibility - undesirable for non-Asian languages that is

Fortunately the issue is soon fixed.
Press ALT+F11. This opens the macro editor. Press
CTRL+G (View > Immediate Window). This provides a 'chat' window in
which you can type vba code to be executed immediately. In that window,
type
Options.UseCharacterUnit
=False and press the enter key.