Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I do not want to expand the cell as my comments are quiet long.
They appear just fine in some cells but not in others. All the text is there and can be read but if I format the cell from general to text that's when it changes it to ####. -- A. "PCLIVE" wrote: At the top of your sheet, double-click between the two columns with the column that has the #### on the left. For example, if cell C5 is displaying ####, then double-click on the line between C and D at the top of your sheet. This should automatically widen the column as necessary in order to display the full contents. "Andmor" wrote in message ... I am entering comments on student performance. The other cells that i have filled in are quite long and have the text appear just fine without making the colums bigger. -- A. "John" wrote: Have you tried to make the column wider? What text are you entering? -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Andmor" wrote: I have been entering text into cells formatted for text. That is until I have reached some cells that are formatted for text but the text comes out ####. Any suggestions? I even tried to apply the formatting from a cell where the text appears correctly but have had no success. -- A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number Stored as text Error | Excel Worksheet Functions | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Text Error Message | Excel Worksheet Functions | |||
How to change and error message to text | Excel Worksheet Functions | |||
Text and the #VALUE error | Excel Worksheet Functions |