How do I stop an apostrophe from disappearing?

[Guest]

I want a cell to read 'text' (with both apostrophes). It show up like this
in the equation bar, but not the cell (first spostrophe is missing).
Changing the "transistion navigation keys" box does nothing.
Thanks in advance!

 

[Guest]

Try apostrophe apostrophe text apostrophe. It worked for me.

 

[Dave Peterson]

excel figures you mean that this cell should be treated as text when you type
that initial apostrophe.

(that's why NWilcox suggested two apostrophes.)

 

[Guest]

I suppose the easiest answer is always in fact, the correct one. Thanks!