Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers Converted to Text - Last Digit Replaced by Zero | Excel Worksheet Functions | |||
Why has my cell text been replaced by # characters? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
text replaced by #### | Excel Discussion (Misc queries) |