Blank Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
One more option.

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

This won't format the cells, though.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Sorting a list of numbers 3
Insert Blank Row with data match change 1
Having Blank Cells, etc. ? 1
After Macro runs, no cell activated - what am I missing? 2
Blank Suppression 3
Conditional Formatting assistance 7
Average cells based on column header 6

Back
Top