ExcelBanter - #DIV/0! hiding

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #DIV/0! hiding (https://www.excelbanter.com/excel-discussion-misc-queries/16886-div-0-hiding.html)

GJR3599

#DIV/0! hiding

how can i make a #DIV/0! message either hide, or appear as a 0.00 or
something else that would look better in a spreadsheet?

All times are GMT +1. The time now is 02:38 AM.