Thread
:
remova of decimal palces
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
remova of decimal palces
Chip,
May I ask why not:
=FLOOR(A1,SIGN(A1))
or even:
=TRUNC(A1)
Which as far as I can see return the same result.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Chip Pearson" wrote in message
...
Olu,
Use a formula like:
=FLOOR(ABS(A1),1)*SIGN(A1)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"oasalako1" wrote in message
...
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