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

=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

Thanks,
I tried IIF(), that did not work, did not try IF() Yet.

GJ


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

IIF isn't a worksheet function (well, in the USA version).

But it is a function in VBA.

gjack72 wrote:

Thanks,
I tried IIF(), that did not work, did not try IF() Yet.

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