Text does not appear in cell, instead "#########..."
 

Typing text into cell, but when complete and click off cell, text does not
appear in cell. Instead a series of pound signs (#) appear in cell. Text
appears in other cells, but this particular cell only shows pound signs when
the cell is not selected.

Please advise! Thank you.

Text does not appear in cell, instead "#########..."
 

try widening the column

--
Don Guillett
SalesAid Software

"Carissa" wrote in message
...
Typing text into cell, but when complete and click off cell, text does not
appear in cell. Instead a series of pound signs (#) appear in cell. Text
appears in other cells, but this particular cell only shows pound signs
when
the cell is not selected.

Please advise! Thank you.

Text does not appear in cell, instead "#########..."
 

If re-sizing the cell oes not fix the problem, then format the cell as
General rathr than Text.
--
Gary's Student


"Carissa" wrote:

Typing text into cell, but when complete and click off cell, text does not
appear in cell. Instead a series of pound signs (#) appear in cell. Text
appears in other cells, but this particular cell only shows pound signs when
the cell is not selected.

Please advise! Thank you.

Text does not appear in cell, instead "#########..."
 

Have you tried to auto fit the cell

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=567190

Text does not appear in cell, instead "#########..."
 

Thank you, changing the format to general fix the problem.

"Gary''s Student" wrote:

If re-sizing the cell oes not fix the problem, then format the cell as
General rathr than Text.
--
Gary's Student


"Carissa" wrote:

Typing text into cell, but when complete and click off cell, text does not
appear in cell. Instead a series of pound signs (#) appear in cell. Text
appears in other cells, but this particular cell only shows pound signs when
the cell is not selected.

Please advise! Thank you.

Text does not appear in cell, instead "#########..."
 

Carissa

Excel has a problem with cells that contain text with length between 255 and
1024 characters ans shows the ### signs.

Format the cell(s) to General and should go away.


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 12:14:02 -0700, Carissa
wrote:

Typing text into cell, but when complete and click off cell, text does not
appear in cell. Instead a series of pound signs (#) appear in cell. Text
appears in other cells, but this particular cell only shows pound signs when
the cell is not selected.

Please advise! Thank you.