Formulas showing a value instead of a blank cell

[ToyMiller]

I am doing a vlookup from a different workbook and in the cell where the formula is, some of the cells are "blank" and others have a "0" in them......... I don't remember how to make is so the cell is blank if the value from the vlookup is 0 or NULL.

Thanks in advance...

 

[pgc01]

Hi

Use the custom format:

[=0]"";General