What do pound signs mean in excel

I am keeping this in my favorites bar. Thank you so much! This problem has been very frustrating and now, using your advice, it is fixed. Thanks, again! I seem to have a slightly different issue. The cell is set for the Date format. 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 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.

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. 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?

Deb, I am extremely new to Excel, I have Excel 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.

Quick Tip: To quickly set the column to the width of the widest cell in that column, simply double click the column heading border where your mouse turns into the double arrows. The cells in that column will adjust to the width of the widest cell. Toggle navigation. Technology KnowledgeBase. In Excel, why is this cell showing a bunch of pound signs.

There should be a number in there. Filed Under: Word, Excel, and Powerpoint. Attached Files. Related Articles. How do I turn tables in Excel to switch columns to rows and vice versa?

Added on Mon, Jun 29, How do you add screen shots to a PowerPoint slide? Added on Tue, Jul 14, In Word how do you save a single page as a PDF? How do you merge cell contents in Excel?

How do I Added on Mon, Jul 20, In Word, how do I change the text direction? How do I move pages in Word ? How do I copy a formula in Excel? All Categories. ActivStudio and Interactive Whiteboards BYOD 2. District Mobile Devices Email, Calendars and Contacts in Outlook Login Accounts and Passwords Mac OS and Applications BiTech 3. How to Create Matrices on a TI How to Find Zeros of Functions in Excel. How to Work Out Percentages in Excel. How to Draw an Array in Math. How to Do Algebra in Excel.

How to Calculate the Percent Change in Excel. How to Decrease Digits in Excel. How to Draw a Normal Distribution in Excel. How to Make Frequency Tables. How to Calculate Cell Concentration.