Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text not wrapping within a cell | Excel Discussion (Misc queries) | |||
linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
Cell Capacity - text | Excel Discussion (Misc queries) | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions |