View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default drop the decimal without rounding

The INT function others have suggested will work fine as long as your
numbers are all positive values. However, if you can have negative value,
then you should use this instead...

=ROUNDDOWN(A1,0)

--
Rick (MVP - Excel)


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