View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
Posts: 82
Default remova of decimal palces

On Jul 3, 9:40 am, oasalako1
wrote:
Hi, I am trying to make my figure e.g 123,456.78 to be 123,456. I do not want
to see the decimal place and I don't want it to round it up to be 123,457.

Anyone can tell me what formula to use?

Thanks
Olu


Try =ROUNDDOWN(123456.78,0)