How can I bypass "formula errors"?

Copper Contributor

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; however, as you can clearly see, these aren't intended formulae. When I move on to the next cell, whatever I just typed immediately turns into "#NAME?" How can I bypass this error so it doesn't think they're supposed to be formulae?

 

Thanks.

1 Reply

@Hunter_D 

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.