remova of decimal palces
 

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

remova of decimal palces
 

On Jul 3, 9:40 am, 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

Try =ROUNDDOWN(123456.78,0)

remova of decimal palces
 

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

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

remova of decimal palces
 

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

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

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 -