Thread: A non roundup decimal place cell format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nakal Nakal is offline
external usenet poster
  
Posts: 2
Default A non roundup decimal place cell format


I am looking for an excel cell format which allows a 2 decimal place number
to be
displayed as a single decimal number without the excel roundup which
normally occurs

eg display 13.68 as 13.6 , not as 13.7 and also NOT change the underlying
value.

ie I am looking for a number format to change the display not a math
function eg TRUNC or ROUNDDOWN which change the underlying value.
Reply With QuoteReply With Quote