Make sure you do this on a copy of your workbook, in case there are
unintended consequences

1) Select the range of cells you want to have affected this way
2) press F5, click on 'Special' and select Blanks, then click on OK
3) Type a 0 (zero) and press Ctrl-Enter



"prince" wrote:

I am trying to place zero in place of empty cells in my worksheet, i used
formula
=IF(A2="",0,A2)
But this formula is also placing zero for a cell having value(number), i
donot want the cells with values to be filled with zero, i want only empty
cells in my sheet to be filled with zero.
can anyone help me plz.