View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default stop rounding in cell

Try this formula:
=INT(A1/1000)
.... where A1 contains 97,654. This formula returns only the integer
value of the "divide by 1000" math.