If they are truly blanks you can use the following, select the whole range,
press F5, select special and check Blanks, press enter. Type 0 and press ctrl
+ enter
format as 0.00


Regards,

Peo Sjoblom

"Josh" wrote:

I have a 300 row column with values in some of the rows. How can I select
the column range and insert 0.00 into all blank cells?