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