Help with Looping through a Column

[golfnut019]

I want to loop through the rows of a specific column and with a conditional statement, I want to set every #N/A equal to zero. ( the value )

Any tips on how to start?

 

[thunderfoot]

Could try highlighting the column in question and using the EXCEL Edit/Replace!!

 

[golfnut019]

So I guess I'm making it more complicated than it should be eh?


Thanks

 

[ChrisM]

Or use a formula like =if(iserror(A1),0,A1)