A cell displays many ###'s instead of the text data.
 

Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?

Expand the column width?

"BelAir" wrote in message
...
: Cell is formatted to wrap. Surrounding cells are ok.
:
: How do we display the text?

BelAir,

This usually means the column isn't wide enough.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"BelAir" wrote in message
...
Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?

If widening the column does not help.........

Excel has problems with cells that are formatted as Text when the number of
characters reaches 250 or so.

Format the cells as General and see if that helps.


Gord Dibben Excel MVP

On Thu, 20 Jan 2005 08:15:04 -0800, BelAir
wrote:

Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?

Doesn't it (it does) "come back" at some point Gord?

When testing this, I copied and pasted several times, and the text returned
?!?!?!
While the format was *still* Text !

STRANGE !
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
If widening the column does not help.........

Excel has problems with cells that are formatted as Text when the number of
characters reaches 250 or so.

Format the cells as General and see if that helps.


Gord Dibben Excel MVP

On Thu, 20 Jan 2005 08:15:04 -0800, BelAir

wrote:

Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?

Gord' Message was very helpful and worked. THANKS for all of your input.


"RagDyeR" wrote:

Doesn't it (it does) "come back" at some point Gord?

When testing this, I copied and pasted several times, and the text returned
?!?!?!
While the format was *still* Text !

STRANGE !
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
If widening the column does not help.........

Excel has problems with cells that are formatted as Text when the number of
characters reaches 250 or so.

Format the cells as General and see if that helps.


Gord Dibben Excel MVP

On Thu, 20 Jan 2005 08:15:04 -0800, BelAir

wrote:

Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?

Yes RD, it does "come back" after a point.

At 255+ chars the Text-formatted cell produces ###############

From my tests it starts showing text again when the number of characters goes
over 1024.


Gord

On Fri, 21 Jan 2005 07:47:06 -0800, "RagDyeR" wrote:

Doesn't it (it does) "come back" at some point Gord?

When testing this, I copied and pasted several times, and the text returned
?!?!?!
While the format was *still* Text !

STRANGE !

Interesting !

Thanks Gord.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Yes RD, it does "come back" after a point.

At 255+ chars the Text-formatted cell produces ###############

From my tests it starts showing text again when the number of characters
goes
over 1024.


Gord

On Fri, 21 Jan 2005 07:47:06 -0800, "RagDyeR" wrote:

Doesn't it (it does) "come back" at some point Gord?

When testing this, I copied and pasted several times, and the text returned
?!?!?!
While the format was *still* Text !

STRANGE !

Thanks Gord - I just encountered this problem for the first time. I changed
the format to General and the issue was resolved.

"Gord Dibben" wrote:

If widening the column does not help.........

Excel has problems with cells that are formatted as Text when the number of
characters reaches 250 or so.

Format the cells as General and see if that helps.


Gord Dibben Excel MVP

On Thu, 20 Jan 2005 08:15:04 -0800, BelAir
wrote:

Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?

A cell displays many ###'s instead of the text data.
 

Thank you Thank you Thank you! I've been battling with this problem forever.
You'd think this w/b included in Help for Excel--it's a pretty basic problem.

"Gord Dibben" wrote:

If widening the column does not help.........

Excel has problems with cells that are formatted as Text when the number of
characters reaches 250 or so.

Format the cells as General and see if that helps.


Gord Dibben Excel MVP

On Thu, 20 Jan 2005 08:15:04 -0800, BelAir
wrote:

Cell is formatted to wrap. Surrounding cells are ok.

How do we display the text?