The macro to average columns states that "empty cells are not counted so they do not affect the average, but cells with a zero in them are counted and they do affect the average".
My tests show me that if the cell contains contains "0." or "0 " the behavior is as specified (i.e., the 0 is included) but a simple "0" without any other characters in the cell is ignored.