=if(a1="","",a1)
or
=if(sheet2!a1="","",sheet2!a1)


gjack72 wrote:

I am linking my source workbook to a destination workbook.
When I have a link with no data in the source cell, it is giving it a
value of '0'
in my destination cell. How do I get the destination to show a null
value
like my source cell.

Thanks,

GJ

--
gjack72
------------------------------------------------------------------------
gjack72's Profile: http://www.excelforum.com/member.php...o&userid=30375
View this thread: http://www.excelforum.com/showthread...hreadid=500323

--

Dave Peterson