View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default remova of decimal palces

The OP didn't mention anything about negative numbers !!

Pete

On Jul 5, 12:45 am, "Sandy Mann" wrote:
You could use:


=INT(A1)


Unless A1 is negative whereupon -123,456.78 will become -123,347 which I
assume the OP does not want.
--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message

ups.com...



You could use:


=INT(A1)


Hope this helps.


Pete


On Jul 3, 3:40 pm, 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- Hide quoted text -


- Show quoted text -