Specifying number of decimals in a number
 

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

Specifying number of decimals in a number
 

In Excel, 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 the
=TRUNC funcion, e.g. =TRUNC(123.4567,3)


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=557633

Specifying number of decimals in a number
 

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