Office for Mac Issues

Fix Question Mark in a Box Around Numbers in Excel for Mac

Huda QurayshiHuda Qurayshi Nov 13, 2026 868 views

Question details

The user needs to stop Microsoft Excel for Mac 2019 from automatically adding question mark or replacement box characters around numbers typed with the numeric keypad, without affecting normal typing in Word.

Fix Question Mark in a Box Appearing Around Numbers in Excel for Mac
Product
Microsoft Excel for Mac 2019
Device & OS
macOS
Scenario
The user is entering numeric data with the numeric keypad in Excel for Mac and needs clean numbers in cells and the formula bar.
Observed behavior
Excel displays a number with question mark or box replacement characters on both sides, even though the user only typed the number; Word and other apps work normally.
Before you start

Before changing Excel settings, open Notes or Word and type with the numeric keypad, then verify that the correct macOS keyboard layout and input source are selected.

Solution 1Recommended

Test the Numeric Keypad and Check the macOS Input Source

Use this first to confirm whether the keyboard itself or the macOS layout is causing the unexpected character.

Because Word and other apps may handle numeric keypad input differently, a quick keyboard test outside Excel narrows the cause before you change Excel settings.

1
Test the keypad in Notes

Open Notes on your Mac, create a new note, click in the note body, and type the same numbers on the numeric keypad.

2
Check the result in Word as a second test

Open a blank Word document and type numbers with the numeric keypad. If Notes and Word insert plain numbers, the keyboard is likely working correctly.

3
Verify the active input source

Go to System Settings > Keyboard > Input Sources, or System Preferences > Keyboard > Input Sources on older macOS, and confirm the correct language and keyboard layout are selected.

4
Remove conflicting input sources

Select the layout that matches your numeric keypad, and remove or disable extra input sources that may convert numeric keypad codes into replacement characters.

Good news if other apps work: If Notes and Word type numbers normally, focus on Excel workbook settings, formatting, add-ins, or an Excel update instead of replacing the keyboard.
Free Microsoft Office alternative

Use WPS Office as a Free Excel for Mac Alternative

Because this numeric keypad replacement-character issue is caused by Microsoft Excel for Mac, WPS Office gives you a free, lightweight spreadsheet alternative with familiar formatting tools, full .xlsx compatibility, and easier migration from your existing workbooks.

  1. 1. Download and install WPS Office: Go to the WPS Office download page, download the macOS version, and install WPS Office on your Mac.
  2. 2. Open the affected workbook: Launch WPS Spreadsheets, click Open, and select the .xlsx file that previously showed question mark boxes in Excel for Mac.
  3. 3. Continue working and save: Edit the numbers normally, then save the file as .xlsx to keep it fully compatible with Microsoft Excel.
Enter numbers normally without Excel for Mac-specific numeric keypad replacement charactersOpen, edit, and save .xlsx workbooks with Microsoft Excel format compatibilityFree, lightweight Office suite for macOS with a familiar ribbon-style interfaceSeamless migration from Excel for Mac without losing your spreadsheet data
microsoft office alternative - wps office

Frequently Asked Questions

Why does the question mark in a box appear only in Excel on Mac and not in Word?

Excel may be interpreting the numeric keypad input through a different input source, workbook-specific number format, or add-in. Test the keypad in Notes or Word and check System Settings > Keyboard > Input Sources to confirm the expected macOS layout is active.

How do I check the macOS keyboard layout for Excel numeric keypad problems?

Open System Settings > Keyboard > Input Sources, or System Preferences > Keyboard > Input Sources on older macOS, and make sure the correct language layout is selected. Remove extra input sources that may remap numeric keypad keys into replacement characters.

Will updating Excel for Mac fix the question mark box around numbers?

If the problem also occurs in a new blank workbook after an input source check, update Excel beyond version 16.14. In Excel, go to Help > Check for Updates or run Microsoft AutoUpdate to install the latest update.

Can copying data into a new workbook remove the unexpected question mark boxes?

Yes, when the issue is workbook-specific. Create a new workbook with File > New Workbook, paste the data, select the affected cells, and use Home > Clear > Clear Formats to remove unusual number formatting.

Does WPS Office open the same Excel files if I want to avoid this glitch?

Yes. WPS Spreadsheets opens .xlsx files and lets you edit and save them in Excel-compatible format, which is useful when Excel for Mac keeps adding unexpected numeric keypad characters.