View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Roger is offline
external usenet poster
 
Posts: 226
Default how to make value whole (remove decimal point)

I have a column with values that have up to 4 places to the right of the
decimal point (32.2514) and I simply want the whole value rounded up, and I
don't want it just to show the rounded up value, I actually want the cell
value to be 32 if the number is 32.2145. please help.....

thanks