Populate blank cell with "0"

[Drew K.]

Greetings,

Is there a simple way to replace blank cells within a
spreadsheet with a value? I attempted a CTRL+H but cannot
figure out the proper value for "Find what:".

Thanks in advance,
Drew

 

[Ken Wright]

Select the entire area, do Edit / Go To / Special / Blank cells - Then type 0 and hit CTRL+ENTER.

 

[Drew K.]

Ken,

Great tip! Thanks very much.

-----Original Message-----
Select the entire area, do Edit / Go To / Special / Blank

cells - Then type 0 and hit CTRL+ENTER.