Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
prjman
 
Posts: n/a
Default wrapping of very long text in EXCEL 2002 cells

I have a very long text with multiple lines in one cell (formatted as text).
That cell shows(and prints) only #####################...
When I select the cell is shows the proper text lines in the toolbar.
Autowrap is turned on, but does not seem to working for this cell (it does
for others). I tried making the row hight large enough to show it, but no
luck. I need to keep the column width fixed.

How can format the cell to have autowrap work correctly?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default wrapping of very long text in EXCEL 2002 cells

Use ALT+ENTER at the point where the text is to break
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"prjman" wrote in message
...
I have a very long text with multiple lines in one cell (formatted as
text).
That cell shows(and prints) only #####################...
When I select the cell is shows the proper text lines in the toolbar.
Autowrap is turned on, but does not seem to working for this cell (it
does
for others). I tried making the row hight large enough to show it, but no
luck. I need to keep the column width fixed.

How can format the cell to have autowrap work correctly?



  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default wrapping of very long text in EXCEL 2002 cells

Re-format as General.

Excel has a problem when the number of characters is between 255 and 1024.


Gord Dibben MS Excel MVP

On Thu, 15 Jun 2006 10:51:02 -0700, prjman
wrote:

I have a very long text with multiple lines in one cell (formatted as text).
That cell shows(and prints) only #####################...
When I select the cell is shows the proper text lines in the toolbar.
Autowrap is turned on, but does not seem to working for this cell (it does
for others). I tried making the row hight large enough to show it, but no
luck. I need to keep the column width fixed.

How can format the cell to have autowrap work correctly?


  #4   Report Post  
Posted to microsoft.public.excel.misc
prjman
 
Posts: n/a
Default wrapping of very long text in EXCEL 2002 cells

Thanks for your quick feedback, Bernard.
I had already used Alt+enter to separate the lines within the cell. So there
must me something else to do.

Regards,
prjman


"Bernard Liengme" wrote:

Use ALT+ENTER at the point where the text is to break
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"prjman" wrote in message
...
I have a very long text with multiple lines in one cell (formatted as
text).
That cell shows(and prints) only #####################...
When I select the cell is shows the proper text lines in the toolbar.
Autowrap is turned on, but does not seem to working for this cell (it
does
for others). I tried making the row hight large enough to show it, but no
luck. I need to keep the column width fixed.

How can format the cell to have autowrap work correctly?




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 should have a hanging indent for long text entries kxxxk Excel Discussion (Misc queries) 4 November 4th 09 03:00 PM
I am using wrap text in excel, so why isn't all my text wrapping? GatorDawg123 Excel Discussion (Misc queries) 2 May 6th 06 05:52 PM
Truncated wrapped text cells in Excel RichK Excel Discussion (Misc queries) 1 April 12th 06 07:45 PM
moving text from a word document to excel gregp22 New Users to Excel 2 March 21st 06 07:18 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM


All times are GMT +1. The time now is 04:10 PM.

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

About Us

"It's about Microsoft Excel"