ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help with Excel 2003 cell # (https://www.excelbanter.com/excel-worksheet-functions/140275-help-excel-2003-cell.html)

riccopalermo

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.

Duke Carey

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.


RagDyeR

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.




riccopalermo

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.





RagDyeR

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