Thread: Blank Cells
View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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?