Prev: Subtraction of 2 numbers/cells
Next: Counting Cells in a column depending on another column but excluding duplicates
From: Gord Dibben on 11 Apr 2010 11:49
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

On Sun, 11 Apr 2010 08:26:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il> wrote:

>Thank you.
>The 255-1024 was what I was looking for.
>BUT I still have one important question because of the IF [quote]:
>"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" wrote:
>
>> 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
>>
>> --
>>
>> Dave Peterson
>> .
>>

From: מיכאל (מיקי) אבידן on 11 Apr 2010 12:24
....and is this problem [256-1024] related to all versions, of "Excel", or is
it unique to a single version only ?
Micky


"Dave Peterson" wrote:

> 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
>
> --
>
> Dave Peterson
> .
>
From: מיכאל (מיקי) אבידן on 11 Apr 2010 13:01
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" wrote:

> 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
>
> On Sun, 11 Apr 2010 08:26:01 -0700, ????? (????) ?????
> <micky-a*at*tapuz.co.il> wrote:
>
> >Thank you.
> >The 255-1024 was what I was looking for.
> >BUT I still have one important question because of the IF [quote]:
> >"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" wrote:
> >
> >> 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
> >>
> >> --
> >>
> >> Dave Peterson
> >> .
> >>
>
> .
>
From: Dave Peterson on 11 Apr 2010 15:35
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.

????? (????) ????? wrote:
>
> 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" wrote:
>
> > 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
> >
> > On Sun, 11 Apr 2010 08:26:01 -0700, ????? (????) ?????
> > <micky-a*at*tapuz.co.il> wrote:
> >
> > >Thank you.
> > >The 255-1024 was what I was looking for.
> > >BUT I still have one important question because of the IF [quote]:
> > >"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" wrote:
> > >
> > >> 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
> > >>
> > >> --
> > >>
> > >> Dave Peterson
> > >> .
> > >>
> >
> > .
> >

--

Dave Peterson
From: Dave Peterson on 11 Apr 2010 15:38
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".

????? (????) ????? wrote:
>
> ...and is this problem [256-1024] related to all versions, of "Excel", or is
> it unique to a single version only ?
> Micky
>
> "Dave Peterson" wrote:
>
> > 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
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Subtraction of 2 numbers/cells
Next: Counting Cells in a column depending on another column but excluding duplicates