Hi
choose edit / goto and click on the special button
choose blanks and click ok
this will select all the empty cells
then (without clicking anywhere) type a
0
and press
control & enter
this will put a 0 in all the selected cells
- note, it is a good idea to try something like this on a copy of your
workbook first.
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"prince" wrote in message
...
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.