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).