How to escape characters in Microsoft Excel, such as an equals sign?

[lee91]

Hi, how can I escape characters in Microsoft Excel? I want to have a column of equal signs, but Excel interprets the equals signs as the beginning of a formula. How would I do this? Thanks!

[Simon Lloyd]

Use an apostrophe or stet '

[Bob Phillips]

Stet gives me an error. I don't see any way that you can avoid formulas.

[Simon Lloyd]

Stet gives me an error. I don't see any way that you can avoid formulas.

Bob i do this sometimes while working on formula i simply do this:
'=
it will then just show = even if you complete a formula, well at least in xl2010.

[Bob Phillips]

Bob i do this sometimes while working on formula i simply do this:
'=
it will then just show = even if you complete a formula, well at least in xl2010.

Oh I see, I thought you meant you entered '= in the Find dialog (which is how I read the OPs request).

[Aussiebear]

Maybe James Thurber was reading the post to you Bob?

[mdmackillop]

Hi, how can I escape characters in Microsoft Excel? I want to have a column of equal signs, but Excel interprets the equals signs as the beginning of a formula. How would I do this? Thanks!

You could also format your column as Text.