Formula Errors

Why the @ Symbol No Longer Starts Excel Formulas (And How to Adapt)

Adam Davis Oct 10, 2026 871 views

Question details

Users want to know why entering a formula starting with the @ symbol is no longer recognized properly in modern versions of Excel and how to correctly input formulas instead.

Why the @ Symbol No Longer Starts Excel Formulas

Product: Microsoft Excel
Device & OS: not provided
Scenario: Entering basic or complex mathematical calculations and functions into a spreadsheet cell.
Observed behavior: When typing a formula beginning with an @ symbol, Excel may throw an error, fail to calculate, or evaluate it as an implicit intersection rather than recognizing it as a standard formula prefix.

Before you start

Verify your current spreadsheet software version, as the shift from using @ as a legacy Lotus 1-2-3 prefix to the modern implicit intersection operator is prominent in Microsoft 365 and Excel 2021.

Solution 1Recommended

Start All Formulas with the Equals Sign (=)

The most robust and highly recommended solution is to transition your habits to start all formulas with an equals sign (=), which is the universal standard for modern spreadsheet tools.

While older spreadsheet programs like Lotus 1-2-3 allowed the @ symbol to initiate functions (e.g., @SUM), modern Excel versions strictly reserve the @ symbol for the implicit intersection operator.

Retraining yourself to use the = symbol prevents unexpected calculation errors and ensures your formulas work across all spreadsheet platforms.

Select the target cell

Click on the specific cell in your worksheet where you want the formula result to appear.

Type the equals sign

Press the '=' key on your keyboard to initiate the formula mode. Do not type the '@' symbol.

Enter your function

Type the rest of your desired function, such as '=SUM(A1:A10)', and press the Enter key to calculate the result.

Start All Formulas with the Equals Sign (=)

Universal Compatibility: Using the = sign guarantees full compatibility across all modern spreadsheet platforms, including Microsoft Excel, Google Sheets, and WPS Office.

Solution 2

Enable Lotus Compatibility for Legacy Worksheets

If you are strictly bound to older data entry methods or are reviewing old legacy sheets, you can temporarily enable a setting to allow the @ symbol to act as a formula prefix.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Calculations with WPS Office

If you are tired of dealing with confusing legacy settings and unexpected formula behavior in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that utilizes standard modern formula conventions without the hassle.

1. Download the software: Visit the official WPS Office website to download and install the free suite on your device.
2. Open your existing spreadsheets: Launch WPS Spreadsheet and instantly open your Excel files without losing formatting or data.
3. Write standard formulas: Select any cell, press '=' to start your formula, and experience straightforward and accurate calculations.

Completely free to use with an intuitive, familiar tabbed interface.Seamlessly opens and edits Microsoft Excel formats including .xlsx, .xls, and .csv.Reliable formula engine that strictly follows standard '=' prefix rules without complex legacy conflicts.Lightweight application footprint that runs smoothly on older devices and multiple operating systems.

microsoft office alternative - wps office

Frequently Asked Questions

What is the @ symbol used for in modern Excel?

In modern versions of Excel (such as Microsoft 365 and Excel 2021+), the @ symbol is specifically designated as the implicit intersection operator. It is used to force a formula to return a single value rather than spilling an array into adjacent cells.

Will updating my older Lotus spreadsheets break my formulas?

If you open older files where you previously used the @ symbol for Lotus compatibility, Excel usually converts those legacy formulas to modern ones starting with an equals sign (=) automatically. However, manual entry of @ to start a formula will no longer work unless legacy transition options are manually enabled.

Can I use the @ symbol for functions in WPS Spreadsheet?

WPS Spreadsheet adheres to modern standard spreadsheet conventions. You should use the standard equals sign (=) to start all formulas and functions to ensure proper calculations and avoid syntax errors.

Excel & Data Problems