Excel 2002 always rounds up automatically

  • Thread starter Thread starter Kent
  • Start date Start date
K

Kent

Dear all,
Don't know why when I input the numeric 179510085292681233, it always rounds
up to 179510085292671000.
I'm using Excel 2002 SP3 version.


Kent
 
David Biddulph said:
If you need more digits, enter as text
Click to expand...

.....If you intend to use the "number" as text, for example a credit card
identifier.

If you enter 179510085292681233 as text, then use it in an arithmetic
expression, you will not get any more precision.


That is odd. I cannot speak for Excel 2002 SP3, but....

First, Excel 2003 SP3 __truncates__, not rounds, the first 15 significant
digits when entered manually. If I manually type 12345678901234567890, the
resulting value is the same as the constant 12345678901234500000.

Second, the first 15 significant digits of 179510085292681233 are
179510085292681. So the resulting value should be the same as the constant
179510085292681000, regardless of whether Excel 2002 SP3 rounds or truncates
the first 15 significant digits.

Oh, perhaps Kent simply has a typo, and he is misusing the word "round", as
so many people do in these forums.


----- original message -----
 
I see, thank you David & Joe

Kent




Joe User said:
....If you intend to use the "number" as text, for example a credit card
identifier.

If you enter 179510085292681233 as text, then use it in an arithmetic
expression, you will not get any more precision.



That is odd. I cannot speak for Excel 2002 SP3, but....

First, Excel 2003 SP3 __truncates__, not rounds, the first 15 significant
digits when entered manually. If I manually type 12345678901234567890,
the resulting value is the same as the constant 12345678901234500000.

Second, the first 15 significant digits of 179510085292681233 are
179510085292681. So the resulting value should be the same as the
constant 179510085292681000, regardless of whether Excel 2002 SP3 rounds
or truncates the first 15 significant digits.

Oh, perhaps Kent simply has a typo, and he is misusing the word "round",
as so many people do in these forums.


----- original message -----
Click to expand...
 
Back
Top