Office for Mac Issues

Fix Japanese Characters Showing as Question Marks in Excel Formula Bar on Mac

Nimra MalikNimra Malik Nov 13, 2026 868 views

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.

Fix Japanese Characters Showing as Question Marks in Excel Formula Bar on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Help menu

In Excel for Mac, open the Help menu in the top menu bar.

2
Check for Updates

Select Check for Updates and allow Microsoft AutoUpdate to search for available updates.

3
Install updates and restart Excel

Install any available updates, restart Excel, then reopen the workbook and check whether Japanese characters display correctly in the formula bar.

Update Microsoft Excel for Mac to the Latest Version
Expected result: The Japanese characters should no longer appear as question marks or boxes after updating and restarting Excel.
Free Microsoft Office alternative

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.

Reliable Japanese text rendering in spreadsheet cells and the formula barOpens and saves Microsoft Excel .xlsx and .xls files without conversionFree and lightweight on macOS with a familiar ribbon-style interfaceSeamless migration from Excel with support for common formulas and formatting
microsoft office alternative - wps office

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.