Why doesn't a ' symbol show up at start of Excel cell

G

GClarke IQE

If I type a ' symbol as the first character in a cell it appears on the
formula bar but isn't visible within the cell. Can it be made visible and if
not what is Excel interpreting this symbol as and doing with it?
 
P

PCLIVE

This forces the cell to be viewed as text. Type two apostrophes
consecutively to have one show up at the beginning.

HTH,
Paul
 
Top