Try
=IF(ISBLANK(A2),0,A2)
or
IF(LEN (A2)=0,0,A2)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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.
|