Text replaced with #

[jay_babcock]

In some cells with a large amoutn of text, my text turns into #. The
wrapping and width of column and height of row do not seem to make a
difference... only removing text from the cell... does anyone know what the
problem is

[Gord Dibben]

Jay

One possible reason.

When a cell is formatted as Text and character length is between 256 and 1024
you can get the ###########

Format to General and usually clears up.


Gord Dibben Excel MVP


On Fri, 14 Oct 2005 13:13:02 -0700, "jay_babcock"
<[email protected]> wrote:

>In some cells with a large amoutn of text, my text turns into #. The
>wrapping and width of column and height of row do not seem to make a
>difference... only removing text from the cell... does anyone know what the
>problem is

[Gary''s Student]

Try changing the format of the cell fromText to General.
--
Gary''s Student


"jay_babcock" wrote:

> In some cells with a large amoutn of text, my text turns into #. The
> wrapping and width of column and height of row do not seem to make a
> difference... only removing text from the cell... does anyone know what the
> problem is

[jay_babcock]

That has no effect. It did work when I changed the number format to Number
though even though it is all text... go figure!

"Gary''s Student" wrote:

> Try changing the format of the cell fromText to General.
> --
> Gary''s Student
>
>
> "jay_babcock" wrote:
>
> > In some cells with a large amoutn of text, my text turns into #. The
> > wrapping and width of column and height of row do not seem to make a
> > difference... only removing text from the cell... does anyone know what the
> > problem is

[Dave Peterson]

Try formatting the cell as General.

jay_babcock wrote:
>
> In some cells with a large amoutn of text, my text turns into #. The
> wrapping and width of column and height of row do not seem to make a
> difference... only removing text from the cell... does anyone know what the
> problem is

--

Dave Peterson