Replacing blank cells with 0 in Excel 2007

4 08 2009

This article has moved to a new location :




5 responses

11 08 2009

Excellent, works! Hard to fin stuff with Excel 2007

27 08 2009

This worked very nicely. Thanks!

3 02 2010
Stuart Resnick

Wonderful, thanks. I had been filling in blank cells using a vba procedure that was very slow checking each cell. Your method should be much faster.

6 02 2010

You are Welcome Stuart,
Yes this method is a lot faster than the VBA method, Glad its of help to you

18 08 2010
Steve Grantham

Thanks for this tip! I figured there had to be an easy way to do this, even though the Excel Help doesn’t address it at all. There seem to be a lot of advice on going the other direction (blank to zero) but I needed to format a sparse spreadsheet for upload to a site that requires explicit zeroes, so this saved me a lot of work.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: