Number format display

[pcw]

1) I format a cell to Number (0 decimal places, and
Negative numbers as -1234).

2) When I enter a value with more than 15 numbers, the
16th digit and onwards become 0

3) I need to know how to display all the digits even when
they are more than 16 digits. Any ideas?

 

[Peo Sjoblom]

That is all you get with numbers, everything after 15 digits will be
truncated, so to display more you need
a text format.. If you really need to make calculations you need something
else and if for display use text
(or precede entry with apostrophe)

 

[Lady Layla]

To get beyond 15 numbers, it has to be formatted as text. Excel can only deal
with 15 places.


:
: 1) I format a cell to Number (0 decimal places, and
: Negative numbers as -1234).
:
: 2) When I enter a value with more than 15 numbers, the
: 16th digit and onwards become 0
:
: 3) I need to know how to display all the digits even when
: they are more than 16 digits. Any ideas?