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
 

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

Space at end of multi page list to accommodate new entries 1
Issue with blanks and spaces 56
Dealing with a Pivot Table (when I don't want to) 0
Copying Portions of Data 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Using FIND to highlight text (with dashes) 4
Sort column beginning with blank? 1
IF funtion question 1

Top