Cell appearance

[P. Zicari]

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.

 

[Dave O]

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

 

[muddan madhu]

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