Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 - Cell Borders | Excel Discussion (Misc queries) | |||
Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
How can i test a cell for bold style in a cell (Excel 2003)? | Excel Worksheet Functions | |||
cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
Excel 2003 - Ctrl-End selects last cell. How chg last cell addr? | Excel Worksheet Functions |