Replace blank values with 0 but leave non-blank values alone
I have a sheet with numerous columns that contain dollar (USD) values. Many of the rows have a blank value in these columns, and I would like to change those blank cells to be 0. I was hoping it would be as simple as highlighting the column and using "Find and Replace" to replace all blank values with 0, but I can't seem to "Find and Replace" blank values. If this is possible somehow, that would be perfect, otherwise...
I need a formula that will make all blank values in a column zero BUT if the existing value is not blank, it should be left alone.
Please let me know if either of these things are possible.
Help Article Resources
Check out the Formula Handbook template!