Hi,

I think an IF Formula should work for this.

For example, if your first cell of deposit data is in cell A2 then in a new column type:

=IF(A2="No Deposit", 0, A2)

This formula checks if A2 is the text "No Deposit". If it is it will return 0. If it is not then it will return the original value from A2.

You can then copy this down the whole column for each of the deposit amounts.

I've added a GIFCoach to this to demonstrate, if this helps:
https://www.gifcoach.com/how-to/clea...crosoft-excel/