Fix Minus Sign Formula Errors in Excel for iPad
Question details
The user needs to fix an issue where typing a minus sign in Excel on an iPad immediately results in a formula error.

- Product
- Microsoft Excel
- Device & OS
- iPadOS
- Scenario
- Entering mathematical formulas or negative numbers into an Excel spreadsheet on an iPad.
- Observed behavior
- Typing a minus sign causes a formula calculation error, even in a completely new blank workbook. This issue seems isolated to the iPad, as the exact same action works flawlessly on an iPhone.
Before altering any system settings, connect an external Bluetooth keyboard to your iPad or test typing a minus sign in a different application (like Apple Notes) to determine if the issue stems from the iPad's virtual keyboard or is isolated to the Excel app itself.
Reset the iPad Keyboard Dictionary
Resetting the iOS keyboard dictionary clears out custom learned words and formatting that might be conflicting with Excel's formula bar.
Often, iOS keyboard glitches can interfere with how specialized characters like the minus sign are passed to specific applications. Clearing the keyboard dictionary forces the system to revert to default character behaviors.
Navigate to your iPad's home screen and tap the Settings app.
Go to General, scroll down to the bottom, and tap on 'Transfer or Reset iPad', then select 'Reset'.
Tap on 'Reset Keyboard Dictionary'. You will be prompted to enter your device passcode to confirm.
Force close the Microsoft Excel app by swiping up from the bottom of the screen and swiping the app away, then reopen it to test the minus sign.

Update iPadOS and Microsoft Excel
Software bugs are frequently patched in new updates. Updating both your operating system and the Excel app ensures optimal compatibility.
Try WPS Office for Seamless Mobile Spreadsheets
If Microsoft Excel on your iPad continues to experience calculation glitches or keyboard bugs, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for viewing and editing spreadsheets on your mobile devices without formula errors.
- 1. Download WPS Office: Visit the App Store on your iPad, search for WPS Office, and download the application for free.
- 2. Open Your Excel File: Launch the app and open your existing .xlsx spreadsheet directly from your iPad storage or connected cloud drive.
- 3. Edit Without Errors: Tap any cell to bring up the reliable WPS specialized keyboard. Enter your formulas and minus signs accurately without triggering calculation bugs.

Frequently Asked Questions
Why does the minus sign work in Excel on my iPhone but not my iPad?
This is typically caused by a bug in how iPadOS handles virtual keyboard inputs on larger screens, or a corrupted dictionary file specific to your iPad. Because iPhones use a slightly different keyboard interface, the bug may not replicate there.
Can I use a different character to represent a negative number in an iPad spreadsheet?
Yes. In many accounting and spreadsheet formats, you can wrap a number in parentheses to indicate a negative value. For example, typing (100) will often be recognized and formatted as -100, which can serve as a workaround if the minus key is broken.
Will connecting an external Bluetooth keyboard fix the minus sign error?
Usually, yes. If the bug is strictly related to the iPad's on-screen software keyboard, using an external hardware keyboard (like a Magic Keyboard) bypasses the software input glitch, allowing you to type the minus sign normally.
What should I do if resetting the keyboard dictionary does not solve the Excel error?
If resetting the dictionary and updating your software fails, you should contact Microsoft Support directly. Provide them with your specific iPad model, iPadOS version, and the Excel app version so they can investigate the ongoing bug.




