Get Rid of Number Signs in Excel

In your early days of working in Excel, you probably saw the occasional cell full of number signs (you might call them pound signs or hash marks).

NumberSigns01

That’s a sign that the column is too narrow to show the full number, so number signs are displayed instead.

To fix that problem, widen column C, so there is room for the full number. The quickest way to make the column the correct width is to double-click the line between the headings for columns C and D.

NumberSigns02

Text Cells Filled With Number Signs

What if the column is wide, and the cell contains text, not a number – and it’s full of number signs? In the screen shot below, you can see the text in the formula bar, and the character count (1100) is shown in cell A2. The cell is set for Wrap Text, but the text isn’t being displayed.

NumberSigns03

In this case, widening the column doesn’t fix the problem – you’ll just end up with a wider column of number signs.

For text cells that are showing number signs, set the cell format to General, instead of Text. It’s a strange solution, because Text seems like the logical choice, when formatting a cell that contains text.

NumberSigns04

Here is the same cell, with General format.

NumberSigns05

The good news is that this problem seems to be fixed in Excel 2010.

______________

You may also like...

17 Responses

  1. Dee says:

    This was excellent advice and really helped me out. I am keeping this in my favorites bar.

    Thanks!

  2. Randy says:

    Thank you so much! This problem has been very frustrating and now, using your advice, it is fixed. Thanks, again!

  3. Brad Mundy says:

    Thanks for the tip about setting the cell type to General, Debra. It worked like a charm.

  4. Shardo says:

    You are the best. Thanks for your help. I am bookmarking your page!

  5. BK says:

    Perfect, thank you so much!!

  6. Bucky Dent says:

    Holy crap…thank you. what a freaking pain in the ass!!!!!!!

  7. JBradford says:

    I seem to have a slightly different issue. The cell is set for the Date format. The entry field at the top shows the date (1/22/1921) but the cell shows the generalized number (7693). If I change the format of the cell to General, the cell entry remains unchanged but now the entry field at the top of the screen shows 7693. What is bothersome is that this only occurs with certain cells in a long table, and I cannot find any difference between those cells and the others.

  8. Karin W says:

    My problem is that when I open the excel file I see numbers not #. When others open my files, they see #. Is there something I can do. It’s awkward when I send a file to my manager and he can’t read the numbers without reformatting it.

  9. Jodi says:

    I am having the same problem. I see the text data fine, I send the excel file to a friend and when she opens it some (not, and not many) cells are full of hash tags. If she puts her cursor on the hash tags it shows her what the data is. In our situation I am using a Mac and she is using a windows Microsoft computer, any suggestions?

  10. Sandi L. says:

    Deb, I am extremely new to Excel, I have Excel 2016. I am trying to set up a financial sheet for our Veterans Of Foreign Wars Auxiliary. I have my header done, each of my individual columns set up and label. I have it set on general. I typed in my beginning balances, my first row I typed in the amount and it took it fine, there is plenty of room in the column for the figures but when I click on the next column to enter figures my first column turns to pound signs. Any Help is greatly appreciated. I have never worked with Excel so am totally lost. Also trying to add auto sum??

    • @Sandi, What happens if you make the first column twice as wide as it is now? Does that fix the problem?
      If you point to the cell with the pound signs, does a little box appear, showing the number that is in the cell?
      What format is in the cell? To find out, click on a cell with pound signs, then look on the Home tab of the Ribbon. You should see a Number section, with a word in it, such as “General” or “Number”

  11. Maritta says:

    Can anyone tell me how I can turn off the(C)or(R)signs that default to their company or registration signs please?

    • @Maritta, in Excel, click the File tab, at the top left, then click Options.
      Click the Proofing category, then click the AutoCorrect Option button near the top right
      In the list of AutoCorrect items, click on (c) then click Delete
      Do the same for (r)
      Click OK twice, to exit.

  12. Anna says:

    Worked for me, thanks!

  13. margaret says:

    THANKS..it has really worked

Leave a Reply to Jodi Cancel reply

Your email address will not be published. Required fields are marked *