remova of decimal palces

[oasalako1]

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

 

[ed]

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)

 

[Chip Pearson]

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)

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Pete_UK]

You could use:

=INT(A1)

Hope this helps.

Pete

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Pete_UK]

The OP didn't mention anything about negative numbers !!

Pete