LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JDN
 
Posts: n/a
Default how do I stop my text being truncated at RHS of a cell?

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
 
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 01:44 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"