how to loose all numbers after decimal (not rounding)

  • Thread starter Thread starter arjay9
  • Start date Start date
A

arjay9

Hi everyone, thanks for comming to my aid. Does anyone know how to
format a cell so that any numbers after the decimal point go away. I'm
not tring to round the number to the next whole, I just want to loose
all of the numbers after the decimal.

For example:

If the answer was 4.567 I would like the cell to show 4, not 5. Oh ya,
and to make things more difficult, when that number "4" gets entered
into other formuals I want it to count as 4 and not 4.567, I'm not just
trying to "Hide" the numbers after the decimal, I want the code to throw
them out.

Any help would be greatly appreciated.
 
Hi,

If your number is in cell A1, use the following formula in cell B1 -
int(a1). This will eradicate the decimals after the number

Regards,

Ashish
 
Thanks guys, the "INT" was exactly what I was looking for.

The rounding thing would have worked for my one example, but in
situations when I don't know if I want it to round up or down it
wouldn't have worked.


Thanks again!!!! Have a great night :) :) :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing 0 after decimal with ROUND 5
Addition errors with Decimal Places 5
Count digits before decimals and after decimals 4
Rounding Numbers. 2
Calculate to the third decimal and round up or down in cell 6
Excel Excel 2007 won't stop rounding down my formula results! 5
How to round a number up or down 3
Decimal point in general format 1

Back
Top