Thread: Specifying number of decimals in a number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CaptainQuattro CaptainQuattro is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote