Excel link shows zero value instead of actual amt
 

Linked cell to data in another cell, but the results show as zero (when the
linked cell actually equals 100,000).

Excel link shows zero value instead of actual amt
 

Check that your source data cell actually contains a number, rather than
text. If in doubt, try ISNUMBER(cellref).
--
David Biddulph

"Deb" wrote in message
...
Linked cell to data in another cell, but the results show as zero (when
the
linked cell actually equals 100,000).