Text stored in a cell is displayed as a string of "#####..."
 

What do I need to do to get the stored text to display properly?
--
Dave

Text stored in a cell is displayed as a string of "#####..."
 

expand your column with.
--
RGDS,

RAY


"David Walter" wrote:

What do I need to do to get the stored text to display properly?
--
Dave

Text stored in a cell is displayed as a string of "#####..."
 

I agree, expand your column width...maybe. But that only displays when the
cell is formated as a number or similar, so make sure that your cell is
formated for Text or General. If the General Setting causeing the same
result, switch to Text.
--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"David Walter" wrote:

What do I need to do to get the stored text to display properly?
--
Dave

Text stored in a cell is displayed as a string of "#####..."
 

Excel has a problem with string lengths between 255 and 1024 characters.

Format the cells to General instead of Text and the ####### should go away.


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 09:37:03 -0800, David Walter
wrote:

What do I need to do to get the stored text to display properly?

Text stored in a cell is displayed as a string of "#####..."
 

Ray

OP stated it was text.

Only numbers need wider column if showing ######

See my other post in same thread.


Gord

On Mon, 12 Nov 2007 09:53:00 -0800, Ray wrote:

expand your column with.

Text stored in a cell is displayed as a string of "#####..."
 

Negative dates/times will also show ##############


Gord

On Mon, 12 Nov 2007 11:48:34 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Ray

OP stated it was text.

Only numbers need wider column if showing ######

See my other post in same thread.


Gord

On Mon, 12 Nov 2007 09:53:00 -0800, Ray wrote:

expand your column with.