Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Replacing blanks with Zero

Posted by Brett B on August 06, 2001 3:55 AM

I have blank cells in a sheet. I need to replace these with zero.

Can anyone help

Re: Replacing blanks with Zero

Posted by Mark W. on August 06, 2001 6:27 AM

1. Select a cell range that contains blanks.
2. Choose the Edit | Go To... | Special... menu
command, select "Blanks", and press [ OK ].
3. Type a 0 and press Control+Enter.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.