what formula do I use to change a empty cell to the number zero

Try,

=IF(ISBLANK(B12),0)

This creates a circular reference. You will get a pop up. Just click
on Cancel to allow the formula as is. Copy this to the cells you want
to apply to.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=496984

Select the range to fix
edit|replace
what: (leave blank)
with: 0
replace all

kevin wrote:

what formula do I use to change a empty cell to the number zero

--

Dave Peterson

If the cells are empty you can select the range in question, press F5, click
special and select blanks, press enter, then type 0 and press ctrl + enter

--
Regards,

Peo Sjoblom

(No private emails please)


"kevin" wrote in message
...
what formula do I use to change a empty cell to the number zero