This is manually but not cell after cell.
Select the range in question, press F5, select Special, select Blanks and
press enter or click OK.
Type a zero and enter it with ctrl + enter instead of enter

--


Regards,


Peo Sjoblom


"mcp201" wrote in message
...
Is there an option in Microsoft Excel 2003 to fill in blank cells with a
"0"
without having to manually do it? Thanks in advance.