Thread
:
remova of decimal palces
View Single Post
#
6
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
remova of decimal palces
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann