Formula Errors

How to Fix Unexpected Equal Signs Before Dates and Values in Excel

Steven ParkerSteven Parker Oct 20, 2026 869 views

Question details

Users are experiencing an issue where an equal sign automatically appears before dates and other values within an Excel worksheet.

How to Fix Unexpected Equal Signs Before Dates and Values in Excel
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 you start

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.

Solution 1Recommended

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.

1
Open Excel Options

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.

2
Navigate to Advanced Settings

In the Excel Options dialog box, click on 'Advanced' in the left-hand navigation pane.

3
Locate Lotus Compatibility

Scroll all the way to the bottom of the Advanced settings page until you find the section labeled 'Lotus Compatibility settings for'.

4
Clear Compatibility Options

Uncheck all selected options in this section, such as 'Transition formula evaluation' and 'Transition formula entry', then click 'OK' to save your changes.

Settings Applied: New entries will no longer automatically convert with an equal sign. You may need to manually remove the equal signs from previously affected cells.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer for your operating system.
  2. 2. Install and Launch: Run the installer, open the WPS Spreadsheets application, and enjoy a familiar interface.
  3. 3. Open Your Spreadsheets: Click 'Open' to seamlessly load your existing Excel files and edit them without legacy formatting glitches.
Fully compatible with Microsoft Excel (.xlsx, .xls) formats to ensure smooth file transitions.Free and lightweight, providing a fast and efficient alternative to heavy office suites.Familiar user interface that requires zero learning curve to start editing spreadsheets.Clean default settings that prevent unexpected formula conversions for standard dates.
QA img-9

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.