very easy:

1. Select the area of cells
2. Edit Goto... Special Blanks
3. 0 CNTRL-ENTER

inserting the zero with a CNTRL-ENTER rather then the usual ENTER key will
put the zero into all the blank cells in the area.
--
Gary''s Student - gsnu200766


"BAS" wrote:

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