Fix Japanese Characters Showing as Question Marks in Excel Formula Bar on Mac
Question details
The user needs to restore readable Japanese characters in the Microsoft Excel for Mac formula bar after text began appearing as boxes or question marks.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A user is working in a workbook containing Japanese text and notices that the formula bar no longer previews the characters correctly.
- Observed behavior
- Japanese text in the Excel formula bar appears as boxes or question marks instead of the expected characters.
Confirm the issue appears in the formula bar and note whether it affects all Japanese fonts or only a specific font. Keep your current Excel for Mac version and macOS version available for testing.
Update Microsoft Excel for Mac to the Latest Version
Use this first because Office updates often include font rendering and display fixes for Japanese characters.
Excel for Mac display issues can be caused by outdated code that fails to map Japanese glyphs correctly in editing fields such as the formula bar. Installing the latest update refreshes the font handling components.
In Excel for Mac, open the Help menu in the top menu bar.
Select Check for Updates and allow Microsoft AutoUpdate to search for available updates.
Install any available updates, restart Excel, then reopen the workbook and check whether Japanese characters display correctly in the formula bar.

Validate and Test Japanese Fonts in Font Book on Mac
Use this if updating Excel does not fix the issue, to identify whether a damaged or uninstalled Japanese font is causing the problem.
Switch to WPS Office for Mac for Reliable Japanese Text Editing
If Excel for Mac keeps displaying Japanese characters incorrectly, WPS Office is a free, lightweight Office alternative that opens and saves Microsoft Excel files and provides reliable multilingual text rendering in a familiar spreadsheet interface.

Frequently Asked Questions
Why does Excel for Mac show question marks instead of Japanese characters in the formula bar?
This usually means Excel cannot map the Japanese glyphs for the font assigned to the cell. It can be caused by an outdated Excel version, a missing or damaged Japanese font, or a font conflict on macOS.
How do I update Excel for Mac to fix Japanese character display?
Open Excel, go to Help > Check for Updates, install any available updates through Microsoft AutoUpdate, restart Excel, and reopen the workbook.
How do I validate Japanese fonts on a Mac?
Open Font Book, select the Japanese font, choose File > Validate Font, and check whether Font Book reports warnings or errors for that font.
Which Japanese fonts can I test in Excel for Mac?
Try common macOS Japanese fonts such as Hiragino Sans, Hiragino Mincho ProN, Yu Mincho, or Noto Sans JP, and see whether the formula bar displays them correctly.
Can WPS Office open my Excel file if it contains Japanese text?
Yes. WPS Office for Mac can open and save Excel .xlsx and .xls files and is designed to preserve multilingual text and formatting.




