Why does a number show up instead of my chosen symbol - in Excel?

Answer There may be another type of formatting in the cell which is causing the "text" value to be displayed as a number instead.Try changing the Format to something else, such as "General" or "Text".

Top Q&A For: Why does a number show up instead of my chosen ...

When i press shift+2 i get the @ symbol instead of the" symbol. how can i correct this?

My computer has both keyboard mappings, the US English one gives the @ when SHIFT-2 is pressed, whereas the French Canadian setting gives "Go to Start->Control Panel->(classic mode)->Regional Setti... Read More »

What TV sex symbol appeared as a contestant on The Dating Game but wasn't chosen?

Several celebrities appeared on "The Dating Game," but the best known sex symbol, especially to have not been picked, was Tom Selleck. Among the others to appear were John Ritter, Andy Kaufman, and... Read More »

Does anyone know how to make a star symbol with the alt + (a number on the number pad)?

Try Alt + 9733I couldn't try this on my own computer as I have a new keyboard that's all screwed up, but it might work out for you. If not, sorry.Edit-That one works for the black star, the white ... Read More »

How do I link a title to another sheet in Excel It just shows the number '0' instead of the title?

If by "title" you mean the text at the beginning of a column (or row) that tells what the data in the column (or row) is about, then you need a simple Formula that References the other Worksheet an... Read More »