Re: remova of decimal palces
- From: "Sandy Mann" <sandymann2@xxxxxxxxxxxxxx>
- Date: Wed, 4 Jul 2007 23:25:16 +0100
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
sandymann2@xxxxxxxxxxxxxx
Replace @mailinator.com with @tiscali.co.uk
"Chip Pearson" <chip@xxxxxxxxxxxx> wrote in message
news:84E01818-8574-4FBD-8C78-9983BB358BFD@xxxxxxxxxxxxxxxx
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" <oasalako1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8574A774-7301-46A6-8ABC-9A5309CEDAC4@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Multiplying non consecutive rows, than adding it.
- Next by Date: Re: More Questions Re: Sums and Averages by Date
- Previous by thread: Re: remova of decimal palces
- Next by thread: Re: remova of decimal palces
- Index(es):
Relevant Pages
|
