Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default "Centre Across Selection" and character limit

The problem I have been having is when I type text into a cell it limits me
to displaying over 255 characters and instead displays ####

Following advise, I have "avoided merged cells like the plague" and have now
tried using centre across selection instead but I am still getting the same
problem. I have tried using alt+enter less than every 100 characters but the
display character limit is still occuring and shows ####, even in print
preview.

Note: I have read most of the threads regarding this and have tried:
I am not using multiple monitors
I have tried the Run: Excel /o command
I am running Excel 2003
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default "Centre Across Selection" and character limit

Change the cell's format to General (or anything but Text).



upsidedown_pw wrote:

The problem I have been having is when I type text into a cell it limits me
to displaying over 255 characters and instead displays ####

Following advise, I have "avoided merged cells like the plague" and have now
tried using centre across selection instead but I am still getting the same
problem. I have tried using alt+enter less than every 100 characters but the
display character limit is still occuring and shows ####, even in print
preview.

Note: I have read most of the threads regarding this and have tried:
I am not using multiple monitors
I have tried the Run: Excel /o command
I am running Excel 2003


--

Dave Peterson
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
"Center across selection" rather than "Merge cells" Elardus Excel Discussion (Misc queries) 10 November 6th 08 02:28 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
How do I get "centre across selection" to centre properly? Marjon Excel Discussion (Misc queries) 5 March 17th 06 12:24 AM
Changing Selection for the "Center Across Selection" alignment johnandsuzie Excel Discussion (Misc queries) 1 January 18th 06 04:48 PM
Icon for "Wrap" and for "Centre Across Selection" BeSmart Excel Worksheet Functions 2 November 16th 05 06:44 PM


All times are GMT +1. The time now is 11:45 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"