Excel link shows zero value instead of actual amt

D

Deb

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

David Biddulph

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