Large integers in cells

J

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
 
N

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
[email protected]
 
J

juha.immonen

Nick said:
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.
Click to expand...

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
 
D

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.
 
B

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
Click to expand...
"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?
 
Top