Thread: Truncating to two decimals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
  
Posts: 400
Default Truncating to two decimals
try:
0.01*int( 897.15818*100)


"Phil H" wrote:

Is there a way to trunkate to two decimals without rounding? For example:
123.45*31/12 = 318.9125 I need 318.91
234.97*42/11 = 897.15818, I need 897.15
Reply With QuoteReply With Quote