The cell is probably formatted as text.
Format as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"SuziQ" wrote in message ...
|I have entered formula
| =('L:\Quality Improvement Projects\2008\[2008 Advanced Directive
| Monitor.xls]Summary by Provider'!c10)
|
| It does not bring the information from worksheet Summary by Provider to the
| new worksheet. It just displays the formula in the cell. What am I doing
| wrong.