Number of characters to be displayed in a cell

  • Thread starter מיכ×ל (מיקי) ×בידן
  • Start date
×

מיכ×ל (מיקי) ×בידן

A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky
 
D

Dave Peterson

This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? said:
A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky
 
×

מיכ×ל (מיקי) ×בידן

Thanks for responding.
I don't know if microsoft.public.excel.misc is the same as "Discussions in
Excel General Questions" but even of so - this is, unfortunately, not what
I'm looking for.
The 1'024 displayed versus 32,767 typed is very well known to me.
The thread I'm looking for dealt with some sort of displaying ###### while
no wrapping nor changing the cells size fixed the problem.
Someone responded and said that the problem raises if the user types an
amount of characters.
[He mentioned 2 figures, which I don't remember. They could have been
between 512 and 1024]
I also don't remember if the problem had something to do with "Excel"s
version [maybe "2007" or "2010"]
Unfortunately, the Search feature - while after a string or posts of by
supporter name - in al DG "su*ks
It returns only one page with non-sorted posts etc...
I still hope someone will remember/find this post or the one who responded
will see my question.
Micky


Niek Otten said:
Hi Micky,

Although it is a lot less ago than a gew weeks, you may mean this one:

http://groups.google.com/group/micr...acters+in+cell+group:*Excel*#84b4437d23a68efd

Mind the line breaks in the URL

Or check directly microsoft.public.excel.misc, Apr 8, 6:27 PM

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

מיכ×ל (מיקי) ×בידן said:
A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for
me].
Thanks in advance,
Micky
 
×

מיכ×ל (מיקי) ×בידן

Thank you.
The 255-1024 was what I was looking for.
BUT I still have one important question because of the IF
:
"If you see ###'s in a cell that's formatted as text and the length of the
string
is between 255 and 1024, you'll have this trouble".

*** Is there any chance that upon typing 256 characters in a General
formatted cell could lead to displaying all the 256(!) characters without the
###'s ?
Micky


Dave Peterson said:
This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? said:
A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky
 
G

Gord Dibben

If the cell is formatted as General you should be able to see up to 1024
chars without any #####

It is only when formatted as Text that the #### problem occurs.


Gord

Thank you.
The 255-1024 was what I was looking for.
BUT I still have one important question because of the IF
:
"If you see ###'s in a cell that's formatted as text and the length of the
string
is between 255 and 1024, you'll have this trouble".

*** Is there any chance that upon typing 256 characters in a General
formatted cell could lead to displaying all the 256(!) characters without the
###'s ?
Micky


Dave Peterson said:
This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? said:
A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky
 
×

מיכ×ל (מיקי) ×בידן

....and is this problem [256-1024] related to all versions, of "Excel", or is
it unique to a single version only ?
Micky


Dave Peterson said:
This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? said:
A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky
 
×

מיכ×ל (מיקי) ×בידן

Thank you for emphasizing the 'Text'/'General' format.
I checked it and, indeed, when the cell is formatted as 'Text' I can see the
correct typed characters between 256-1023 [incl.] otherwise it presents ####.
However - I typed 1024 the letter "G" and continued with the letter "B" -
so, I ended up with a more than 1,200 characters in one cell [checked with
LEN] - all of which I was able to see [after resizing the cell] - at least
1,211 character so, now, I wonder how this gets together with the 1,024
character displaying limit per cell.
Could it be related to the characters width ?
Thanks again,
Micky


Gord Dibben said:
If the cell is formatted as General you should be able to see up to 1024
chars without any #####

It is only when formatted as Text that the #### problem occurs.


Gord

Thank you.
The 255-1024 was what I was looking for.
BUT I still have one important question because of the IF
:
"If you see ###'s in a cell that's formatted as text and the length of the
string
is between 255 and 1024, you'll have this trouble".

*** Is there any chance that upon typing 256 characters in a General
formatted cell could lead to displaying all the 256(!) characters without the
###'s ?
Micky


Dave Peterson said:
This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? wrote:

A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky

.
 
D

Dave Peterson

The explanation that makes the most sense to me was posted by Tom Ogilvy.

Very old versions of excel (xl95 and before????) only allowed 255 characters in
the cell. When xl97 came out, the limit was increased to 32k -- but only 1024
characters are allowed in formulas (when measured in R1C1 reference style).

His guess that it was a bug that one (or all??) of the developers missed. The
numbers seem to match up nicely -- but it's a guess.

????? (????) ????? said:
Thank you for emphasizing the 'Text'/'General' format.
I checked it and, indeed, when the cell is formatted as 'Text' I can see the
correct typed characters between 256-1023 [incl.] otherwise it presents ####.
However - I typed 1024 the letter "G" and continued with the letter "B" -
so, I ended up with a more than 1,200 characters in one cell [checked with
LEN] - all of which I was able to see [after resizing the cell] - at least
1,211 character so, now, I wonder how this gets together with the 1,024
character displaying limit per cell.
Could it be related to the characters width ?
Thanks again,
Micky

Gord Dibben said:
If the cell is formatted as General you should be able to see up to 1024
chars without any #####

It is only when formatted as Text that the #### problem occurs.


Gord

Thank you.
The 255-1024 was what I was looking for.
BUT I still have one important question because of the IF
:
"If you see ###'s in a cell that's formatted as text and the length of the
string
is between 255 and 1024, you'll have this trouble".

*** Is there any chance that upon typing 256 characters in a General
formatted cell could lead to displaying all the 256(!) characters without the
###'s ?
Micky


:

This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? wrote:

A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky

.
 
D

Dave Peterson

It started with xl97 (if I recall correctly). See that other response in the
other branch of this thread. And continues through xl2007.

I'm not sure if xl2010 still has this "feature".

????? (????) ????? said:
...and is this problem [256-1024] related to all versions, of "Excel", or is
it unique to a single version only ?
Micky

Dave Peterson said:
This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? said:
A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky
 
×

מיכ×ל (מיקי) ×בידן

Thanks again.
Since my last post I have read a few more reference, to that "problem".
Most of the posters call it a "Bug" and it seems to be such.
I checked and found that "Excel 2007/2010" behave exactly like the previous
versions - meaning, they suffer from the same "bug" [the gap between 256-1024
that displays ####s].
Micky


והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
מנהל ×¤×•×¨×•× "×ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


Dave Peterson said:
It started with xl97 (if I recall correctly). See that other response in the
other branch of this thread. And continues through xl2007.

I'm not sure if xl2010 still has this "feature".

????? (????) ????? said:
...and is this problem [256-1024] related to all versions, of "Excel", or is
it unique to a single version only ?
Micky

Dave Peterson said:
This question has been posted lots of times and responded to even more!

If you see ###'s in a cell that's formatted as text and the length of the string
is between 255 and 1024, you'll have this trouble.

Change the format to General and the problem goes away.

It's not a problem with wrapping the text. It's a problem with the text format
and the length of the string.

But there can be a problem seeing more than about 1000 characters in a cell --
with or without wrapping.

One way around the problem is to insert alt-enters (to force new lines within
the cell) every 80-100 characters. You may have to manually adjust the
rowheight to see much more of the text.



????? (????) ????? wrote:

A few weeks ago I have read, in this DG, an answer regarding this issue.
I hardly remember the answer but it had to do with "Wrapping" and if the
number of characters typed are between X and Y the result will be #######.
I will appreciate if anyone can provide a direct link to that thread [I'm
sure that who responded, to that question, will be able to locate it for me].
Thanks in advance,
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top