Tags: cell, contains, displayed, dragging, excel, instead, microsoft, msdn, software, spreadsheet, text

What does ####### mean in an Excel cell? The cell contains text.

On Microsoft » Microsoft Excel

8,865 words with 6 Comments; publish: Thu, 22 May 2008 20:37:00 GMT; (30693.75, « »)

In an Excel spreadsheet cell I have text but cannot see it. Instead

######### are displayed. I have tried dragging the right side of cell and

wrapping the text to see it but to no avail.

All Comments

Leave a comment...

  • 6 Comments
    • Maybe a *negative* time value.

      A1 = 9:00

      B1 = 8:00

      C1 = ( =B1-A1) would duplicate your problem.

      --

      HTH,

      RD

      ==============================================Please keep all correspondence within the Group, so all may benefit!

      ==============================================

      "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:6EF67D56-C3D9-409E-AEF3-939FBA5F5FBE.excel.todaysummary.com.microsoft.com...

      > In an Excel spreadsheet cell I have text but cannot see it. Instead

      > ######### are displayed. I have tried dragging the right side of cell and

      > wrapping the text to see it but to no avail.

      #1; Thu, 22 May 2008 20:38:00 GMT
    • Nope. no time value used in the cell, just text.

      Anyone who would like me to email them the file itself - just give me your

      email address.

      "RagDyer" wrote:

      > Maybe a *negative* time value.

      > A1 = 9:00

      > B1 = 8:00

      > C1 = ( =B1-A1) would duplicate your problem.

      > --

      > HTH,

      > RD

      > ==============================================> Please keep all correspondence within the Group, so all may benefit!

      > ==============================================>

      > "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:6EF67D56-C3D9-409E-AEF3-939FBA5F5FBE.excel.todaysummary.com.microsoft.com...

      > > In an Excel spreadsheet cell I have text but cannot see it. Instead

      > > ######### are displayed. I have tried dragging the right side of cell and

      > > wrapping the text to see it but to no avail.

      >

      #2; Thu, 22 May 2008 20:39:00 GMT
    • Then you're experiencing the "text' bug!

      Format the cell(s) to "General".

      There seems to be a quirk (bug), where in a Text formatted cell of more then

      approximately 256 characters, you'll get the ###'s.

      Stranger yet, if you keep typing, the true text *returns* when the character

      count exceeds 1024.

      General format should work for the "in-between" character count.

      --

      HTH,

      RD

      ==============================================Please keep all correspondence within the Group, so all may benefit!

      ==============================================

      "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:316DB687-CD18-43B5-8E52-336D9BE56F3B.excel.todaysummary.com.microsoft.com...

      > Nope. no time value used in the cell, just text.

      > Anyone who would like me to email them the file itself - just give me your

      > email address.

      > "RagDyer" wrote:

      > > Maybe a *negative* time value.

      > >

      > > A1 = 9:00

      > > B1 = 8:00

      > > C1 = ( =B1-A1) would duplicate your problem.

      > > --

      > > HTH,

      > >

      > > RD

      > > ==============================================> > Please keep all correspondence within the Group, so all may benefit!

      > > ==============================================> >

      > >

      > > "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > > news:6EF67D56-C3D9-409E-AEF3-939FBA5F5FBE.excel.todaysummary.com.microsoft.com...

      > > > In an Excel spreadsheet cell I have text but cannot see it. Instead

      > > > ######### are displayed. I have tried dragging the right side of cell

      and

      > > > wrapping the text to see it but to no avail.

      > >

      > >

      #3; Thu, 22 May 2008 20:40:00 GMT
    • The only time I've ever seen that is when there's a cell containing a

      formula isn't wide enough to display the value. For grins and giggles, I'll

      look at it. Send it to this address.

      --

      JoAnn Paules

      MVP Microsoft [Publisher]

      "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:6EF67D56-C3D9-409E-AEF3-939FBA5F5FBE.excel.todaysummary.com.microsoft.com...

      > In an Excel spreadsheet cell I have text but cannot see it. Instead

      > ######### are displayed. I have tried dragging the right side of cell and

      > wrapping the text to see it but to no avail.

      #4; Thu, 22 May 2008 20:41:00 GMT
    • You nailed it! That's the problem. Is there a downloadable fix for it?

      "RagDyer" wrote:

      > Then you're experiencing the "text' bug!

      > Format the cell(s) to "General".

      > There seems to be a quirk (bug), where in a Text formatted cell of more then

      > approximately 256 characters, you'll get the ###'s.

      > Stranger yet, if you keep typing, the true text *returns* when the character

      > count exceeds 1024.

      > General format should work for the "in-between" character count.

      > --

      >

      > HTH,

      >

      > RD

      > ==============================================> Please keep all correspondence within the Group, so all may benefit!

      > ==============================================> "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:316DB687-CD18-43B5-8E52-336D9BE56F3B.excel.todaysummary.com.microsoft.com...

      > > Nope. no time value used in the cell, just text.

      > >

      > > Anyone who would like me to email them the file itself - just give me your

      > > email address.

      > >

      > > "RagDyer" wrote:

      > >

      > > > Maybe a *negative* time value.

      > > >

      > > > A1 = 9:00

      > > > B1 = 8:00

      > > > C1 = ( =B1-A1) would duplicate your problem.

      > > > --

      > > > HTH,

      > > >

      > > > RD

      > > > ==============================================> > > Please keep all correspondence within the Group, so all may benefit!

      > > > ==============================================> > >

      > > >

      > > > "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > > > news:6EF67D56-C3D9-409E-AEF3-939FBA5F5FBE.excel.todaysummary.com.microsoft.com...

      > > > > In an Excel spreadsheet cell I have text but cannot see it. Instead

      > > > > ######### are displayed. I have tried dragging the right side of cell

      > and

      > > > > wrapping the text to see it but to no avail.

      > > >

      > > >

      >

      #5; Thu, 22 May 2008 20:42:00 GMT
    • Nope. The fix is to format that cell as general.

      PaulS wrote:

      > You nailed it! That's the problem. Is there a downloadable fix for it?

      > "RagDyer" wrote:

      > > Then you're experiencing the "text' bug!

      > >

      > > Format the cell(s) to "General".

      > >

      > > There seems to be a quirk (bug), where in a Text formatted cell of more then

      > > approximately 256 characters, you'll get the ###'s.

      > >

      > > Stranger yet, if you keep typing, the true text *returns* when the character

      > > count exceeds 1024.

      > >

      > > General format should work for the "in-between" character count.

      > > --

      > >

      > >

      > > HTH,

      > >

      > >

      > > RD

      > > ==============================================> > Please keep all correspondence within the Group, so all may benefit!

      > > ==============================================> >

      > > "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > > news:316DB687-CD18-43B5-8E52-336D9BE56F3B.excel.todaysummary.com.microsoft.com...

      > > > Nope. no time value used in the cell, just text.

      > > >

      > > > Anyone who would like me to email them the file itself - just give me your

      > > > email address.

      > > >

      > > > "RagDyer" wrote:

      > > >

      > > > > Maybe a *negative* time value.

      > > > >

      > > > > A1 = 9:00

      > > > > B1 = 8:00

      > > > > C1 = ( =B1-A1) would duplicate your problem.

      > > > > --

      > > > > HTH,

      > > > >

      > > > > RD

      > > > > ==============================================> > > > Please keep all correspondence within the Group, so all may benefit!

      > > > > ==============================================> > > >

      > > > >

      > > > > "PaulS" <PaulS.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > > > > news:6EF67D56-C3D9-409E-AEF3-939FBA5F5FBE.excel.todaysummary.com.microsoft.com...

      > > > > > In an Excel spreadsheet cell I have text but cannot see it. Instead

      > > > > > ######### are displayed. I have tried dragging the right side of cell

      > > and

      > > > > > wrapping the text to see it but to no avail.

      > > > >

      > > > >

      > >

      > >

      --

      Dave Peterson

      #6; Thu, 22 May 2008 20:43:00 GMT