B
Bill H
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
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