Value of 0 to leave the cell blank

[excel on the run]

Just cant seem to get this to work. In cell V1 the formula is =E78 when E78 is empty it leave a 0 in V1.
How do i get that to show as blank? [FONT=&quot]=IFERROR([/FONT][FONT=&quot]E78[/FONT][FONT=&quot],"") dosent seem to work.
Thanx in advance for your help.

[/FONT]

 

[mikerickson]

Try
=IFERROR(E78/SIGN(LEN(E78)), "")

 

[excel on the run]

Thanx for responding that isn't working. It does leave the cell V1 blank however when there is something entered into E78, V1 stays blank.

 

[Rick Rothstein]

Thanx for responding that isn't working. It does leave the cell V1 blank however when there is something entered into E78, V1 stays blank.

What about this formula...

=IF(E78="","",E78)

 

[excel on the run]

works perfect, thanx.... Brian