Replacing blank cells with 0 in Excel 2007

4 08 2009

This article has moved to a new location :

http://www.learnersdesk.com/index.php?id=60

About these ads

Actions

Information

5 responses

11 08 2009
Wiz

Excellent, works! Hard to fin stuff with Excel 2007

27 08 2009
Tracy

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
vincirufus

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s




Follow

Get every new post delivered to your Inbox.

%d bloggers like this: