Specifying number of decimals in a number

[allencr]

When I type a number say 123.45678 and specify 3 decimals using Format ->
cells -> Number Tab -> Number category my result is 123.457. I believe it
should have been 123.456. Like wise if I specify 4 decimals I get 123.4568
instead of 123.4567. What am I doing wrong? I am using Excel 2003 SP 2
--
Thanks
Allen

[CaptainQuattro]

In Excel formatting, a number will always round up if the next decimal is 5 or greater, and will round down if the next decimal is less than 5.

If you want to truncate numbers without rounding up, use a formula containing the
=TRUNC function in, e.g. =TRUNC(123.4567,3)

[allencr]

Sorry Folks
Looks like the explanation is that Excel was rounding.
--
Thanks
Allen


"allencr" wrote:

> When I type a number say 123.45678 and specify 3 decimals using Format ->
> cells -> Number Tab -> Number category my result is 123.457. I believe it
> should have been 123.456. Like wise if I specify 4 decimals I get 123.4568
> instead of 123.4567. What am I doing wrong? I am using Excel 2003 SP 2
> --
> Thanks
> Allen