How can a cell appear blank but have a formula

[Jack-P-Winner]

I am trying to wrote some formulas in several cells and its leaving a 0 in some of the cells. Is there a way to write a formula n a cell and it remains blank until it becomes true?

In my example I have 2 sheets, 1 is called E-O and the other EEOO, in B:8 I have =EEOO!B8 and in P:8 I have =EEOO!P8. It is putting a 0 in P:8 - S:8 and I would like for it to be blank until I actually enter the data on sheet EEOO

Ive noticed when I program on my Office 2010 it leaves 0s in B:8 - F:8 so I decided to do it on my Office 2013 and this is what I am getting

Thanks

 

[Asheesh]

Custom format to General;General;;

 

[Jack-P-Winner]

Custom format to General;General;;

Do you mean go to format cells and custom general from there? Id so , I tried that and it does not work, it still leaves a 0 in the cell. If that is not what you are talking about can you explain please?

Thanks

 

[Asheesh]

Follow the below steps

1) Select data from P4 to S19..on tab E-O

2) Press CTRL + 1

3) See image below

 

[Hui]

I would recommend using the custom format of
;;;
instead

 

[Jack-P-Winner]

Follow the below steps

1) Select data from P4 to S19..on tab E-O

2) Press CTRL + 1

3) See image below
View attachment 15028

Thank you!!!

 

[Jack-P-Winner]

I would recommend using the custom format of
;;;
instead

Hui,

Where would I place them in my formulas?

 

[Ottrree]

Alternatively: go to File => Options => Advanced. Scroll down the list to "Show a zero in cells that have zero value." Uncheck the box.

 

[Hui]

Its a Custom Cell Format

Follow Asheesh's instructions above except use the folowing codes instead of what I said above
#;#;;

 

[Jack-P-Winner]

Alternatively: go to File => Options => Advanced. Scroll down the list to "Show a zero in cells that have zero value." Uncheck the box.

OMG, so easy, Thanks!!!!