Hi Josh
select your column
then choose edit / goto and click the Special button
choose blanks
click Ok
type 0.00 and press control & enter
this should put it into every selected cell - if the formatting is not
correct, change the formatting before you click on another cell to unselect
the range.
Hope this helps
Cheers
JulieD
"Josh" wrote in message
...
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?
|