Text replaced with #
 

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

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"
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

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

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

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