is there a formula to get rid of decimals in an excel cell?

[cantona_007]

Hi,

I'm really new to excel (2007). But i've managed to create a worksheet that tracks payments for me and my coworkers. I made it such that it tracks the outcome of post-dated payments as well. i used one of the conditional formatting options (3 symbols circled)... so if there's a payment posting today... i enter 1, and then a checkmark is displayed right next to it, if its one for a future date i enter 0.5 and then an exclamation mark is displayed, and if a payment doesnt go thru i enter 0 and then a red x mark is displayed.

Now, the problem is i also have a running total that keeps track of how many payments you've had for the month. only that when i enter the 0.5 it adds to your total and i dont want this. is there a formula that would make the running total ignore the 0.5 and only add the 1 to its total??


Thank you so much.

 

[texasalynn]

one final thing (i promise)... is there a way i can lock the scroll bar to a specific range like say from A1:P70...this way the scroll bar wont go beyond that range??


thanks again.

you can hide the rows and columns beyond the range you want visible