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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I show a flashing symbol in an Excel sheet? 2
How do I format a cell in Excel to show a dash instead of 0.00? 2
How do I get an inserted symbol to show in another worksheet? 1
Formatting Cell that Contains If/Then Formula 5
Symbol for new line in cell 6
Paste link, showing #### in one cell 1
Insert symbol after drop-down is made 6
Formula result not displaying correctly 2

Top