Bob,

Check the formatting of the cell (Format menu, Cells item, Number tab) and
ensure that the formatting is NOT text. Change it to General or some
numeric format and re-edit the formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"RGO" wrote in message
...
We are using Microsoft Office XP and have an Excel file with three
worksheets. A worksheet named 'List' has the raw data. The second
worksheet is named 'Grid', which is the formatted stuff. 96 cells in
'Grid' have formulas that point to cells in 'List'. An example pasted into
this email: =List!A35

The problem: The majority of the cells display the correct values, but
several display the formula. If the formula is deleted and retyped, the
problem is NOT fixed - the formula still displays, not the linked value.

My colleague tells me that this sort problem did not exists with Microsoft
Office 2000.

If anyone has experience with this problem, please let us know.

Thanks,
Bob
Arizona Health Sciences Center
1501 N. Campbell Ave
Tucson, AZ 85724-5030