In column A i have some accts that should have 0 Balances. How can I automate and go through and identify these accounts (0324, 0311,4024, etc.) and then change the "amount" column (column E) to the number 0. There are 5000 lines in this sheet.

TIA.

I would write the following in the column next to your data.

If(or(acc=0324, acc=0311, acc=4024),0,Amount)

Then paste as values and delete the old column.

Tom