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

Re: Cell Text Length

6 views
Skip to first unread message

Dave Peterson

unread,
Aug 21, 2004, 12:50:45 PM8/21/04
to
Try formatting the cell as General. I bet your cell is formatted as Text.

Elisart wrote:
>
> Online help says that a cell will display 1,024 characters...anything longer
> will display the ##### error. I am only able to enter 250 characters before
> getting this display error.
>
> Any suggestions?

--

Dave Peterson
ec3...@msn.com

Gord Dibben

unread,
Aug 21, 2004, 1:09:28 PM8/21/04
to
Elisart

There seems to be a problem with text length between 256-1024 (0-255 and 1025+
work ok).

The bad news is that this is the way Excel works.

Re-formatting the cell(s) to General usually fixes the problem of the
#######'s

Gord Dibben Excel MVP

0 new messages