Forum Discussion
How can I bypass "formula errors"?
Hello, I'm trying to make a grammar chart for word endings, which would basically consist entirely of "formula errors" - that is, for example, entries such as "-us," "-ī," and "-ō" in each cell; ...
Option 1: format the cells you're going to enter these endings in (for example a column) as Text before you start entering values.
Option 2: prefix each such value with a single straight quote '. This instructs Excel to treat the value as text. For example:
'-us
The single quote will be displayed in the formula bar, but not in the cell.