![]() |
Help with Excel 2003 cell #
I typed a bunch of words in a cell. The cell is formated to wrap text and as
text. All I get are ###################. If I click in it it converts to what I typed. I click out and ##############. I have resized the cell to fit the words (oversized it). It is only doing this in one cell although I have words in other cells. Thanks. |
Help with Excel 2003 cell #
AT appropriate places in your cell for line breaks, press Alt-Enter
"riccopalermo" wrote: I typed a bunch of words in a cell. The cell is formated to wrap text and as text. All I get are ###################. If I click in it it converts to what I typed. I click out and ##############. I have resized the cell to fit the words (oversized it). It is only doing this in one cell although I have words in other cells. Thanks. |
Help with Excel 2003 cell #
I would guess that the one cell is formatted to "Text".
Change the format to General, and see what happens. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "riccopalermo" wrote in message ... I typed a bunch of words in a cell. The cell is formated to wrap text and as text. All I get are ###################. If I click in it it converts to what I typed. I click out and ##############. I have resized the cell to fit the words (oversized it). It is only doing this in one cell although I have words in other cells. Thanks. |
Help with Excel 2003 cell #
General did the trick. Why? Does not matter... Thanks.
"Ragdyer" wrote: I would guess that the one cell is formatted to "Text". Change the format to General, and see what happens. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "riccopalermo" wrote in message ... I typed a bunch of words in a cell. The cell is formated to wrap text and as text. All I get are ###################. If I click in it it converts to what I typed. I click out and ##############. I have resized the cell to fit the words (oversized it). It is only doing this in one cell although I have words in other cells. Thanks. |
Help with Excel 2003 cell #
http://tinyurl.com/2rva7v -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "riccopalermo" wrote in message ... General did the trick. Why? Does not matter... Thanks. "Ragdyer" wrote: I would guess that the one cell is formatted to "Text". Change the format to General, and see what happens. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "riccopalermo" wrote in message ... I typed a bunch of words in a cell. The cell is formated to wrap text and as text. All I get are ###################. If I click in it it converts to what I typed. I click out and ##############. I have resized the cell to fit the words (oversized it). It is only doing this in one cell although I have words in other cells. Thanks. |
All times are GMT +1. The time now is 06:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com