Forum Discussion
Excel automatically turns text cell into formula
Anytime I have a cell with "@" symbol leading, excel adds an equal sign and turns it into a formula. Is there any work around for this? Example: I am looking at sports data so when I type "@ COL" e...
Hello Maiko15 ,
What you are seeing is a result of the new Dynamic Array formulas, which are currently available to a small subset of people only. The @ sign has a specific function and as you have found, you cannot start a text entry with an @ sign.
If you type a single quote sign, Excel will treat everything after that as text, so you could use
'@ COL
The single quote will not be visible in the cell, only when it is edited.