Blank Cells
 

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?

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?

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?

One more option.

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

This won't format the cells, though.

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?

--

Dave Peterson