How can you format a cell to be blank after.....

=if(isblank(a2)=true,"",a2)

Assuming the data you want to report is in a2.
Hope that helps : Does anyone know how to stop a cell from displaying 0 when I set it equal to the value of another cell (using the formula: =sheet1!a1) and there is nothing in that cell? cell 2 references cell 1. cell 2 displays "0" I want cell 2 to have nothing in it as well. thanks

General;-General;

...will work; however if cell 2 actually contains
a 0 then it won't be displayed.

Note: You can substitute other types of formatting
(e.g., 0.00) for "General". : Does anyone know how to stop a cell from displaying 0 when I set it equal to the value of another cell (using the formula: =sheet1!a1) and there is nothing in that cell? cell 2 references cell 1. cell 2 displays "0" I want cell 2 to have nothing in it as well. thanks

A third way is to use conditional cell formatting. You can set it so if value = 0 then text color = white. White on white background does not appear. The other two solutions posted are more elegant for your specific case, but this can handle those cases where you actually have a cell value that is zero and is supposed to be zero.