Blank Cells

J

Josh

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?
 
J

JulieD

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
 
P

Peo Sjoblom

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
 
D

Dave Peterson

One more option.

Select your range
edit|replace
what: (leave blank)
with: 0
replace all

This won't format the cells, though.
 
Top