Cell appearance
 

I want the contents of cell A3 to show up in cell b51. What I have done is
in cell B51 I put the formula =A3. The problem is until I enter info into A3
Cell B51 shows a 0. I would like thsi to be an empty cell unitl the info is
entered. Any suggestions?

Thanks in advance.

Cell appearance
 

=IF(ISBLANK(A3),"",A3)

"P. Zicari" wrote:

I want the contents of cell A3 to show up in cell b51. What I have done is
in cell B51 I put the formula =A3. The problem is until I enter info into A3
Cell B51 shows a 0. I would like thsi to be an empty cell unitl the info is
entered. Any suggestions?

Thanks in advance.

Cell appearance
 

An IF formula will work for you:
=IF(a3="","",a3)

"If cell a3 is blank, return a blank; if a3 is anything but blank,
return the value in a3."

Dave O
Eschew obfuscation

Cell appearance
 

select the cell which is showing zero & then go to tools | options |
view tab | under the window option | uncheck the zero values option |
ok



On Jun 3, 7:29*pm, P. Zicari
wrote:
I want the contents of cell A3 to show up in cell b51. *What I have done is
in cell B51 I put the formula =A3. *The problem is until I enter info into A3
Cell B51 shows a 0. *I would like thsi to be an empty cell unitl the info is
entered. *Any suggestions?

Thanks in advance.