V VBA_Newbie Active Member Joined Jan 7, 2005 Messages 258 Sep 20, 2006 #1 Hi folks, Instead of showing "#DIV/0!" when a formula has as the denominator a 0, to just show 0 instead in the cell? All other cells where the formula does not divide by 0 should simply display normally. Is it possible? Many thanks!