Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1 view
Skip to first unread message

PaulS

unread,
Jan 4, 2006, 3:17:02 PM1/4/06
to
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.

RagDyer

unread,
Jan 4, 2006, 3:46:15 PM1/4/06
to
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" <Pa...@discussions.microsoft.com> wrote in message
news:6EF67D56-C3D9-409E...@microsoft.com...

PaulS

unread,
Jan 4, 2006, 4:03:03 PM1/4/06
to
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

unread,
Jan 4, 2006, 4:24:51 PM1/4/06
to
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" <Pa...@discussions.microsoft.com> wrote in message

news:316DB687-CD18-43B5...@microsoft.com...

JoAnn Paules [MVP]

unread,
Jan 4, 2006, 4:51:30 PM1/4/06
to
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" <Pa...@discussions.microsoft.com> wrote in message
news:6EF67D56-C3D9-409E...@microsoft.com...

PaulS

unread,
Jan 4, 2006, 5:16:04 PM1/4/06
to
You nailed it! That's the problem. Is there a downloadable fix for it?

Dave Peterson

unread,
Jan 4, 2006, 9:01:07 PM1/4/06
to
Nope. The fix is to format that cell as general.

--

Dave Peterson

0 new messages