Success!!! it works!!

Thank you : )

"pinmaster" wrote:

Hi,

=IF(Sheet1!A1="","",Sheet1!A1)

the double quotes represent a blank cell

Regards!
Jean-Guy

"SK" wrote:

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