1024 char cell display limit

[Jeff]

Hi,

I'm working on a spreadsheet with some very large numbers.
I'm using Excel 2003 on a 2.4 Ghz P4 proc, w/1GB Ram.
According to article KB269370, Excel will only disply 1024
characters in a cell, though it can use up to 32,767
characters.

I am using an addin to extend Excel's precision from 15
digits to 32767 digits. When my worksheet has a number
that is 1024 digits long, it displays the last line of the
number which is what I want (I have word wrap turned
off). With my formatting, this is the last 125 digits of
the number. [note-excel still calculates correctly for
numbers larger than 1024 digits, it just displays
incorrectly.]

As soon as I have a number that is 1025 digits or more in
length, the cell still displays as a single line, but it
truncates the last approx 50 digits. Instead of showing
the last 125 digits of the number it shows the last 175
digits with the last 50 truncated. So the last 125 digits
are meaningless. I have tried all the combinations of
cell formatting, both vertical and horiz, word wrap
on/off, etc.

I know this is a unique problem, but does anyone know how
to work around this cell display problem?

Thanks,
Jeff

 

[Dave Peterson]

Maybe you can use a helper cell and just pick out the part of the string you
want. You could even hide that column/row so that the helper cell isn't a
distraction:

Maybe
=MID(A1,900,125)


(I don't know how that value is placed into the cell...)

Hi,

I'm working on a spreadsheet with some very large numbers.
I'm using Excel 2003 on a 2.4 Ghz P4 proc, w/1GB Ram.
According to article KB269370, Excel will only disply 1024
characters in a cell, though it can use up to 32,767
characters.

I am using an addin to extend Excel's precision from 15
digits to 32767 digits. When my worksheet has a number
that is 1024 digits long, it displays the last line of the
number which is what I want (I have word wrap turned
off). With my formatting, this is the last 125 digits of
the number. [note-excel still calculates correctly for
numbers larger than 1024 digits, it just displays
incorrectly.]

As soon as I have a number that is 1025 digits or more in
length, the cell still displays as a single line, but it
truncates the last approx 50 digits. Instead of showing
the last 125 digits of the number it shows the last 175
digits with the last 50 truncated. So the last 125 digits
are meaningless. I have tried all the combinations of
cell formatting, both vertical and horiz, word wrap
on/off, etc.

I know this is a unique problem, but does anyone know how
to work around this cell display problem?

Thanks,
Jeff