M
mike marcus
can anybody tell me how I can enter a 17 digit # in a cell without it
rounding off the last 2 digits
rounding off the last 2 digits
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry W. Lewis
Prefix with a single quote so that the value will be interpreted as text.
Excel and almost all other software uses IEEE standard DP double precision
(DP) to store numbers. DP can represent all 15 digit numbers, but only some
16 digit numbers. Rather than explain why numbers with more than 15 digits
changed on entry to other numbers with more than 15 digits, MS decided to
only display 15 digits, as documented in Help.
When you enter a 17 digit number in a cell, it is truncated (not rounded) to
15 digits before conversion to binary.
Jerry
Excel and almost all other software uses IEEE standard DP double precision
(DP) to store numbers. DP can represent all 15 digit numbers, but only some
16 digit numbers. Rather than explain why numbers with more than 15 digits
changed on entry to other numbers with more than 15 digits, MS decided to
only display 15 digits, as documented in Help.
When you enter a 17 digit number in a cell, it is truncated (not rounded) to
15 digits before conversion to binary.
Jerry
M
mike marcus
Jerry W. Lewis said:Prefix with a single quote so that the value will be interpreted as text.
Excel and almost all other software uses IEEE standard DP double precision
(DP) to store numbers. DP can represent all 15 digit numbers, but only some
16 digit numbers. Rather than explain why numbers with more than 15 digits
changed on entry to other numbers with more than 15 digits, MS decided to
only display 15 digits, as documented in Help.
When you enter a 17 digit number in a cell, it is truncated (not rounded) to
15 digits before conversion to binary.
Jerry
that was very helpful, thanks