Forum Discussion
How to get Excel to treat values as text with no functions or cell links?
I have text in an Excel spreadsheet that has @ and = signs. By default, it thinks I want to link a cell into a function whenever I try to copy or update text in a cell. Is there a way to turn off thi...
An apostrophe ' at the beginning of a cell instructs Excel to treat the value as text. In general, the apostrophe won't be included when you copy or export the data,
As an alternative, set the number format of the relevant cells to Text before entering data.
- The apostrophe is not an option since there are several columns and over 600 rows of data. Having to put an apostrophe in every row I touch is less than ideal. Plus, I would like to use it for a different Excel document also which is full of functions and linked cells or ranges. In that case I would also like to turn off Excel trying to link a cell every time I try to copy text from a cell.
