how to loose all numbers after decimal (not rounding)

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

"arjay9" wrote:

>
> 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.
>
>
> --
> arjay9
> ------------------------------------------------------------------------
> arjay9's Profile: http://www.excelforum.com/member.php...o&userid=30421
> View this thread: http://www.excelforum.com/showthread...hreadid=500901
>
>

How about ROUNDDOWN?

=RoundDown(A1,0)

HTH,
Elkar

"arjay9" wrote:

>
> 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.
>
>
> --
> arjay9
> ------------------------------------------------------------------------
> arjay9's Profile: http://www.excelforum.com/member.php...o&userid=30421
> View this thread: http://www.excelforum.com/showthread...hreadid=500901
>
>

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