Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,081
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - Cell Borders oceanmist Excel Discussion (Misc queries) 1 October 23rd 06 07:13 PM
Can Excel 2003 cell link carry with it the source cell format? tom Excel Discussion (Misc queries) 2 July 14th 06 06:14 AM
How can i test a cell for bold style in a cell (Excel 2003)? Mike A. Excel Worksheet Functions 2 March 6th 06 07:23 PM
cell format for date/time in same cell excel 2003 Sandy Excel Worksheet Functions 1 January 18th 06 03:46 AM
Excel 2003 - Ctrl-End selects last cell. How chg last cell addr? Trevose1955 Excel Worksheet Functions 2 December 16th 05 11:25 PM


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"