missing apostrophe

  • Thread starter Thread starter orangetree
  • Start date Start date
O

orangetree

I am making a literacy resource in Excel 2000. What I need is to be able
to enter an apostrophe in a cell and for it to be displayed. There will
be no other text or numbers in the cell - just the apostrophe.

The transition keys box in options is cleared as the help file
suggested, but still the apostrophe is not visible in the cell.

If anyone can help me with this I will be most grateful!

Thanks.
 
put in two single quotes.

The first is interpreted as a formatting character even if transition is
turned off.
 
When an apostrophe is the first character, it is interpreted as an
escape character that indicates that what follows is text (i.e.,
'0123 will be treated as text, not the number 123). It is not
counted as a character, nor, obviously, displayed in the cell.

To display, use a second apostrophe.
 
Back
Top