How to Fix Unexpected Equal Signs Before Dates and Values in Excel
Question details
Users are experiencing an issue where an equal sign automatically appears before dates and other values within an Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering dates or numerical values into worksheet cells.
- Observed behavior
- Excel displays an unexpected equal sign (=) at the beginning of cell entries, often due to Lotus compatibility settings or formula misinterpretation.
Before changing any settings, click on the affected cell and check the formula bar to verify if the equal sign was manually typed or if it is being automatically generated by Excel's compatibility features.
Disable Lotus Compatibility Settings in Excel Options
Turning off Lotus compatibility features prevents Excel from automatically misinterpreting standard text and dates as formulas.
Microsoft Excel includes legacy Lotus 1-2-3 compatibility settings. When 'Transition formula evaluation' is enabled, Excel may automatically add equal signs to certain entries.
Click on the 'File' tab in the top-left corner of the Excel window, then select 'Options' located at the very bottom of the left-hand menu.
In the Excel Options dialog box, click on 'Advanced' in the left-hand navigation pane.
Scroll all the way to the bottom of the Advanced settings page until you find the section labeled 'Lotus Compatibility settings for'.
Uncheck all selected options in this section, such as 'Transition formula evaluation' and 'Transition formula entry', then click 'OK' to save your changes.
Clear Formula Formatting from Affected Cells
If Excel is treating your data as a formula regardless of compatibility settings, you may need to clear the formatting and re-enter the data.
Switch to WPS Office for a Streamlined Spreadsheet Experience
If you frequently encounter frustrating legacy formatting issues like unexpected equal signs in Excel, consider trying WPS Office. It provides a lightweight, highly compatible spreadsheet tool that seamlessly handles modern data entry without the clutter of outdated Lotus settings.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer for your operating system.
- 2. Install and Launch: Run the installer, open the WPS Spreadsheets application, and enjoy a familiar interface.
- 3. Open Your Spreadsheets: Click 'Open' to seamlessly load your existing Excel files and edit them without legacy formatting glitches.

Frequently Asked Questions
Why does Excel add an equal sign when I type a date?
This usually happens when the Lotus Compatibility setting 'Transition formula evaluation' is turned on. It causes Excel to interpret certain date formats or text entries as legacy formulas, automatically prepending an equal sign to the cell.
Can I remove the equal signs from multiple cells at once?
Yes, you can use the Find and Replace feature. Press Ctrl + H, enter an equal sign (=) in the 'Find what' field, leave the 'Replace with' field blank, and click 'Replace All'. Note that this will also remove equal signs from actual formulas, so use this carefully.
Where do I find Lotus Compatibility settings in Microsoft 365?
Even in Microsoft 365 and newer versions of Excel, you can find these legacy settings by navigating to File > Options > Advanced, and scrolling down to the very bottom of the Advanced options window.




