LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Chaim

I have never used 2000 so can't speak for that.

97 shows a portion of the characters. As you decrease the number of chars,
the shown portion decreases in some sort of ratio.

As far as being able to enter 32,767 chars and see only 1024, your guess is as
good as mine.


Gord Dibben Excel MVP


On Thu, 17 Feb 2005 07:58:56 +0000, ChaimB
wrote:


Is this true for EXCEL 2000?

I have a file from a customer which currently has 1022 characters in
one particular cell and I have NOT been able to enter any additional
characters - I did try issuing ALT-ENTER but this does not seem to do
anything.

I have noticed that in EXCEL 2003 I CAN enter many more characters!

For my own edification, what dose the 32 KB limit give me if
operationally I can enter only 1 KB+ number of characters?

Thanks,

Chaim

Gord Dibben Wrote:
Ned

The maximum is 32,767 characters to a cell.

However, as Frank points out, only 1024 will show or can be printed.

Increase the 1024 by using ALT + ENTER at appropriate spots.

Gord Dibben Excel MVP

On Wed, 3 Nov 2004 00:49:04 -0800, "NED 1451" NED
wrote:
-
Can anyone give me some info on the maximum text size you can put in a
cell.
How many characters/words

Thanx.

NED 1451-


 
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
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 07:10 PM
how to hyperlink text to a cell steve New Users to Excel 1 December 14th 04 08:21 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


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