MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.