I am woking in a workbook that has two sheets.

On sheet2, I have formulas that point to sheet1
='sheet1'!C14

When this formula is first created, it correctly shows the value of the
target field.

However, when I edit the formula to something else, i.e.,
='sheet1'!C15

It displays as a string.

At that point, even if I edit to the origional value, it still shows as a
strings.

Any thoughts on how to get the field to work as a formula again ??

Thanks
Bill H