Replacing Blank Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I've exported from Access into Excel. There are approx.
5 columns and over 1400 rows. Each column represents a month, and each row
represents a customer. Some months are blank, which I'd like to
automatically have formatted to read zero. I need to create one formula that
I can copy & paste all the way down the page, for all 1400 customers. When
the blank cells are blank, I can not create the formula.

Any ideas would be greatly appreciated!
 
Where do I enter the formula so that it will apply to the entire sheet? I
want every blank cell to be replaced by a zero.

Thanks!
 
To fill the blank cells:

Select the columns that contain the zeros
Choose Edit > Go To
Click the Special button
Select Blanks, click OK
Type a zero
Press Ctrl + Enter, to fill all the cells
 
Thanks. I had the some situation as Kim (fill blank cells with zeros) and i
just want to say that your sugestion was usefull.

Thanks Debra
 
Back
Top