View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
 
Posts: 510
Default Adding up whole dollars only

Hi Mike,

Have a go with Int() function ...
=INT(A1)

HTH
Carim