Share via

getting hash marks instead of text (and making the cell bigger isn't working)

Anonymous
2012-01-26T17:52:25+00:00

I have a perplexing problem.  In a spreadsheet I created, for others to fill out, there is a table.  In one column of the table a user is to type a brief description.  The cell is formatted to wrap text.  Cell is formatted for text.  Cell is formatted for 9 point font.  Row height is set at 64.50.  I merged five columns together (10.43 width for each column).  So, I have a cell that is 64.50 by 52.15.  In most cases, that should be enough room for what users will type. 

Someone typed in a couple of long sentences (letters, numbers, and punctuation marks), but all that appears on the screen are hash marks (#).  I know that signals that the cell is not large enough to display what is in it.  I increased the row height.  I still got hash marks.  (For printing purposes, I do not want to increase the column width, but I did try, and still got hash marks.)  I took the font size down to 6 and still got has marks.  I took out some of the words (65 characters in total) - went one-by-one, and eventually got the text to appear (thought at that point much was missing).  So it seems as though there are too many characters to display in the cell, but if I make the cell larger, the hash marks do not go away.  The amount of characters is 318 (that includes spaces), which I believe comes no where near the Excel character limit for a cell. 

I copied the text (not the cell, but just the text -- important distinction) to a cell outside the table and do not get hash marks.  When I copy the cell to another cell outside the table, I see nothing but hash marks on the monitor. 

In the other rows of the table, in the same column, hash marks are not displaying (and the formatting in the other rows for that same column is the same as the problem row) -- but in those cells the person typed less text.   

I expanded the height of a blank row elsewhere in the table and typed in the text.  I still got hash marks and the row height was plenty big enough.  When I removed from that cell the minimum number of words I discovered needed to be removed to make the text appear (65 characters), the text did appear and did not come close to filling up the entire cell. 

Based on all that I have done, it seems that the cells in this column will only accept so many characters, not matter how big I make the cell.  I don't understand why that is happening and how to fix.  Anyone out there have an explanation and a fix?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
  1. Anonymous
    2012-01-26T19:31:34+00:00

    Excel has a problem when number of characters is between 255 and 1024 AND the cells are formatted as Text.

    Format to General to get rid of the ########## marks.

    Gord

    90+ people found this answer helpful.
    0 comments No comments

7 additional answers

Sort by: Most helpful
  1. Anonymous
    2012-01-26T22:58:04+00:00

    Bernard

    Quite possibly fixed for 2010......I don't run 2010 but the 2003 and 2007 versions have the

     hashmark problem with Text-formatted cells of 255 to 1024 chars.

    Another quirk............In both versions when you go to Format Cells you will see the hashmarks in "Sample" when you set to Text or General.

    But.............the hashmarks are not displayed in the cell when General but are displayed in the cell when Text

    Gord

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2012-01-26T20:03:13+00:00

    I have inserted 840 characters into 5 merged cells (before merge each had row height 64 and font size 9 with column width 10). The merged range is formatted Text with Text Wrap and the text is readable. (Excel 2010 under Windows 7 64-bit)

    Was this an Xl2007 problem that got solved?

    0 comments No comments
  3. Anonymous
    2012-01-26T18:28:48+00:00

    I'll send it to you be email

    0 comments No comments
  4. Anonymous
    2012-01-26T18:22:40+00:00

    I have just made a worksheet to your specs: row height, column width, font size and 6 merged cells. Into it I pasted some paragraphs from a Word doc. The LEN function tells me I have 1396 characters. I can read them all.

    Does this happen with a new worksheet or with a new workbook? Have you experimented with inserting a new column?

    Can you post the file (or a sample problem file) to a site we can get at (e.g. Skydrive) or can you visit my websiate to get my email and send me a file?

    best wishes

    0 comments No comments