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.
