Replacing Blank Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim - 07 Sep 2005 23:31 GMT

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!

Reply to this Message

Jerry W. Lewis - 07 Sep 2005 23:46 GMT

=IF(ISBLANK(testcell),0,formula)

Jerry

> 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
[quoted text clipped - 4 lines]
>
> Any ideas would be greatly appreciated!

Reply to this Message

Kim - 07 Sep 2005 23:56 GMT

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!

> =IF(ISBLANK(testcell),0,formula)
>
[quoted text clipped - 8 lines]
> >
> > Any ideas would be greatly appreciated!

Reply to this Message

Debra Dalgleish - 08 Sep 2005 00:47 GMT

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

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Rui Guilherme - Mozambique - 23 Oct 2007 07:43 GMT

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

> To fill the blank cells:
>
[quoted text clipped - 13 lines]
> >
> > Any ideas would be greatly appreciated!

Reply to this Message

Rate this thread: