Avoiding a "0" return

[Marvo]

Hi. I have quite a lot of cells that are waiting to be filled once results are in. Simply put. =A1

However this returns "0" if A1 is empty, which is not what I want. I get round this by =if(A1="","",A1)

That works fine but is a bit laborious and I'm wondering if I'm missing a trick (easier way to do it).

Many thanks.

 

[jolivanes]

A one time set-up with a macro for the cells that need the formula.

 

[Scott Huish]

If 0 is not an option you're using for cell data, you could use a number format to hide the 0.

General;-General;

 

[Marvo]

The number format sounds viable, how would I do that? I just changed the format for the cell to number, that didn't work.

 

[Marvo]

Its okay, I've done it. Custom format 0;-0;;@
That works a treat.