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