Thread: drop the decimal without rounding
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default drop the decimal without rounding
A1 = 23.65

=INT(A1)

--
Biff
Microsoft Excel MVP


"annc5411" wrote in message
...
I need to drop the decimals without rounding, so if the answer is 23.65 it
would be 23


Reply With QuoteReply With Quote