Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Roger Govier
 
Posts: n/a
Default

Hi

If the cell to the right of the text is empty, then it should continue the
display past the right boundary. Try pressing the delete button on the
adjacent cells.

Regards

Roger Govier


JDN wrote:
Hi,

Have an Excel report generated by MYOB (small bus accounting package). The
first few columns should format the chart of accounts using a 'tree'
structure.

The issue is that the text is these cells doesn't display past the RHS cell
boundary. i.e. rather than running over into the adjacent cell, the display
is truncated at the rhs cell boundary.

I want this:
Assets
Current Assets
Bank Accounts
Wachovia Checking Account

I get this:
Ass
Curr
Bank
Wachovia Checking Account

How do I tell Excel to allow the text in the first three columns to display
in their entirety?

Thanks,
JD

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
How do I stop Excel auto formatting the text 3-4 as 04 Apr? ahughf Excel Discussion (Misc queries) 3 October 16th 05 10:58 AM
Truncated text when copying text from one excel doc to another sunny pete Excel Discussion (Misc queries) 3 August 12th 05 02:11 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 7 May 17th 05 02:22 AM
Stop text from stringing into next field when empty NothingButRomance Excel Worksheet Functions 2 May 15th 05 05:32 PM


All times are GMT +1. The time now is 07:20 AM.

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"