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

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?

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

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

HTH,
Paul

--

"GClarke IQE" <GClarke wrote in message
...
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?