Make sure that the cell that gets that formula is formated as General (or
anything but Text).

Then re-enter the formula.

You may want:
=if('sf-14'!ag13="","",'sf-14'!ag13)

Then if AG13 on sf-14 is empty, you won't see a 0.

Louise wrote:

how do i get excel to read ='sf-14'!ag13 as a formula. i want the value from
one worksheet to appear on another worksheet.
--
Louise

--

Dave Peterson