I have data from rows 5-3158 (part #'s) and columns B thru M (represents
months), that was populated using a pivot table. Some part numbers were not
puchased every month so the pivot table didn't populate anything, so when I
try to take the average of the row it doesn't work correctly because if it
only populates two columns it takes the average of two instead of 12. I need
to have zero's in the empty cells to get an average over 12 months.

Is there a function to populate these empty cells with "0" so I can get my
correct averages?

Thanks,
BAS