Large integers in cells

[juha.immonen]

Hi

How can I make Excel show integers larger than 15 digits? I mean
without showing it in squares of 10.

123456789012345 is largest I can make fully visible by changing cell
type. After that, for example 1234567890123456 is shown as
1234567890123450 or 1,234567890123450E+14 depending on cell type. But
NOT the way I'd like it.

Is it possible to change the behaviour so I can see as long integer as
fits to cell?

regards
Juha Immonen

 

[Nick Hodge]

Not as an integer, as Excel only displays 15 digits and as you see it then
adds zeroes, so without working in scientific notation...no

If these are really text though (e.g credit card numbers), although you
clearly state integer, you can add a leading apostrophe (') or pre-format
the cell(s) as text. Excel will then display up to 256 in the cell or some
larger number of characters in the formula bar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[juha.immonen]

Not as an integer, as Excel only displays 15 digits and as you see it then
adds zeroes, so without working in scientific notation...no.

But won't it get inaccurate when lets say 12345678901234567890 is
turned to 1,23456789012345000000E+19? Or what did you mean with this
"scientific notation"?

Pre-formatting to text seems to help seeing it all, but I really would
need to do calculations on these, so it's out of question format.
Result field should also have this "feature" and formulas won't fit to
text cells.

I assume this thing is hardcoded without possibility to change even via
registry or anything?

brgds
Juha Immonen

 

[bplumhoff]

Hello Juha,

Look here:
http://digilander.libero.it/foxes/

I have not tested it - but it is mentioned in wikipedia ...

HTH,
Bernd

 

[juha.immonen]

Look here:
http://digilander.libero.it/foxes/
I have not tested it - but it is mentioned in wikipedia ...

Looks very promising, although it's only capable of 200 digits. Does
anyone have experience on this? Might it work with later Excels as
well?

Juha

 

[Dave Peterson]

If you really need that many significant digits, then I think I'd stay away from
excel and try to find a different program.

 

[Bill Sharpe]

Looks very promising, although it's only capable of 200 digits. Does
anyone have experience on this? Might it work with later Excels as
well?

Juha

"only capable of 200 digits" ????
Those are pretty big numbers. Out of curiosity, just what are you doing
that requires working with such large integers?