Forum Discussion
HCStymie1
Mar 23, 2022Copper Contributor
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...
PeterBartholomew1
Mar 23, 2022Silver Contributor
Why not simply use Word? Excel is about calculation whereas you seem to require formatted text.
HCStymie1
Mar 23, 2022Copper Contributor
The data is actually in tabular form for the Excel files I am working with. For the more complicated ones I do copy to a text editor and paste the updated text into excel, but even then it tries to link to the next cell I click on which is annoying. Plus the issue also happens with some other Excel documents that I am just trying to copy text from and don't want to update anything.