PC Review


Reply
Thread Tools Rate Thread

"Centre Across Selection" and character limit

 
 
upsidedown_pw
Guest
Posts: n/a
 
      19th Nov 2009
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      19th Nov 2009
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I get rid of "the expression you entered exceeds the1,024-character limit for the query deisgn grid" annysjunkmail@tiscali.co.uk Microsoft Access Queries 4 21st Apr 2008 10:36 AM
Make the em dash a "break" character for text selection =?Utf-8?B?SmltSCAoRk0p?= Microsoft Word Document Management 0 28th Jun 2006 05:35 PM
Make the em dash a "break" character for text selection =?Utf-8?B?SmltSCAoRk0p?= Microsoft Word Document Management 0 28th Jun 2006 05:35 PM
How do I get "centre across selection" to centre properly? =?Utf-8?B?TWFyam9u?= Microsoft Excel Misc 5 17th Mar 2006 12:24 AM
Icon for "Wrap" and for "Centre Across Selection" =?Utf-8?B?QmVTbWFydA==?= Microsoft Excel Worksheet Functions 2 16th Nov 2005 06:44 PM


Features
 

Advertising
 

Newsgroups
 


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