I should have mentioned that I'm using MS Office 2007. By any chance, would
you know how to access those settings in this version? Also, would this
solution just hide the zeros, or actually use blank values?

Anyhow, thanks for the feedback

"Alan" wrote:

One way would be to click on the menu bar Tools Options Uncheck Zero
Values OK which will hide all zero's in the sheet,
Another would be to use a formula, something like:-
=IF(Sheet2!A1<0,Sheet2!A1,"")
which is saying if Sheet2, A1 is not equal to zero (or blank) then display
the value in that cell, if it is equal to zero (or blank) then display "",
which displays as an empty cell.
Regards,
Alan.
"SK" wrote in message
...
Thanks to everyone in advance..

I am taking values from one XL sheet and using them in another one (with a
simple "=" function). However, values that are blank in the original sheet
show up with a '0' in the new one. Is there a way for a blank to show up
as a
blank? (and if the original blank cell is filled then the new cell gets
filled with that value?)

I don't know any visual basic or anything like that, and I would prefer to
avoid using macros...

Thanks again