Thread: round down?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dbrumit dbrumit is offline
external usenet poster
 
Posts: 5
Default round down?

I want to take cell a1 wich has a value of 111 in it, and multiply that by
..84. I would like the cell to then show 93 and not 93.24
If I format the cell to number and 0 decimal it will show 93 but in the
formula bar it will show 93.24

Can this be done?

Thanks