turning zero into a blank

B

barb

i need a formula that will says IF A1 = 0 then leave cell
blank
Also is there a way to copy patterns? I need to copy down
a column that has data,data,space,space,space,data, all
the way down.

thanks
Barb
 
Top