Formula acting as a string
You're welcome, Bill.
Excel has this habit of changing the format to text if it is bringing
text values from a linked cell - I don't know why the MS programmers
set it up that way.
Pete
On Dec 17, 5:33*pm, Bill H wrote:
Thanks Pete,
Any idea why the format is being reset ?
Thanks
Bill H
"Pete_UK" wrote:
Change the format of the cell to General rather than Text, then double-
click the cell as if to edit it (or press F2) then press <Enter to
commit the change of format.
Hope this helps.
Pete
On Dec 17, 5:07 pm, Bill H wrote:
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- Hide quoted text -
- Show quoted text -
|