If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
######### in text box
I have created a couple of big cells for text. I have word wrap on and if I
type in at least 2 lines of text, when I tab out of the box, the text is turned into a single row of # characters that go across the first line of the box. If I double click into the cell again, the text reappears, but as soon as I click outside, the # characters come back. I have tried adjusting the right edge of the box out to the right some, and this is not doing anything to fix. Any ideas? |
#2
|
|||
|
|||
######### in text box
Sounds as if you've given the cell Text number format. Change it to
General. -- Jim "Rockitman" wrote in message ... |I have created a couple of big cells for text. I have word wrap on and if I | type in at least 2 lines of text, when I tab out of the box, the text is | turned into a single row of # characters that go across the first line of the | box. | If I double click into the cell again, the text reappears, but as soon as I | click outside, the # characters come back. | I have tried adjusting the right edge of the box out to the right some, and | this is not doing anything to fix. | Any ideas? |
#3
|
|||
|
|||
######### in text box
try adjusting column width. You may have the column width too narrow.
"Jim Rech" wrote: Sounds as if you've given the cell Text number format. Change it to General. -- Jim "Rockitman" wrote in message ... |I have created a couple of big cells for text. I have word wrap on and if I | type in at least 2 lines of text, when I tab out of the box, the text is | turned into a single row of # characters that go across the first line of the | box. | If I double click into the cell again, the text reappears, but as soon as I | click outside, the # characters come back. | I have tried adjusting the right edge of the box out to the right some, and | this is not doing anything to fix. | Any ideas? |
#4
|
|||
|
|||
######### in text box
This can also indicate you need to increase the width of the cell by width or
length to view the entire contents of the cell. If there is not enough room to display the entire cell contents it can display # symbols. "Jim Rech" wrote: Sounds as if you've given the cell Text number format. Change it to General. -- Jim "Rockitman" wrote in message ... |I have created a couple of big cells for text. I have word wrap on and if I | type in at least 2 lines of text, when I tab out of the box, the text is | turned into a single row of # characters that go across the first line of the | box. | If I double click into the cell again, the text reappears, but as soon as I | click outside, the # characters come back. | I have tried adjusting the right edge of the box out to the right some, and | this is not doing anything to fix. | Any ideas? |
#5
|
|||
|
|||
######### in text box
Gentlemen, all excellent suggestions. Changing the field from text to
general did the trick. Also, doubleclicking the line between each cell that this box encompasses "straigtened out" some cells that were collapsed. So, multiple cures for the problem at hand. Thanks again. "NYSA-HD" wrote: This can also indicate you need to increase the width of the cell by width or length to view the entire contents of the cell. If there is not enough room to display the entire cell contents it can display # symbols. "Jim Rech" wrote: Sounds as if you've given the cell Text number format. Change it to General. -- Jim "Rockitman" wrote in message ... |I have created a couple of big cells for text. I have word wrap on and if I | type in at least 2 lines of text, when I tab out of the box, the text is | turned into a single row of # characters that go across the first line of the | box. | If I double click into the cell again, the text reappears, but as soon as I | click outside, the # characters come back. | I have tried adjusting the right edge of the box out to the right some, and | this is not doing anything to fix. | Any ideas? |
#6
|
|||
|
|||
######### in text box
Joel
If the data is a number or date this would hold true, otherwise not. OP states "two lines of text". Jim's response is most likely the correct one. Excel has a problem with cells that contain 255 but 1024 characters. Gord Dibben MS Excel MVP On Tue, 22 May 2007 11:42:01 -0700, Joel wrote: try adjusting column width. You may have the column width too narrow. "Jim Rech" wrote: Sounds as if you've given the cell Text number format. Change it to General. -- Jim "Rockitman" wrote in message ... |I have created a couple of big cells for text. I have word wrap on and if I | type in at least 2 lines of text, when I tab out of the box, the text is | turned into a single row of # characters that go across the first line of the | box. | If I double click into the cell again, the text reappears, but as soon as I | click outside, the # characters come back. | I have tried adjusting the right edge of the box out to the right some, and | this is not doing anything to fix. | Any ideas? |
Thread Tools | |
Display Modes | |
|
|