One way:

=IF(Sheet2!$C$2="","",Sheet2!$C$2)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"sea kayaker" <sea wrote in message
...
"pastelink" in excel 2003: blank cells in source worksheet become zeros
in detination worksheet. how can i eliminate them. thanks very much