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 -
|