Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula acting as a string
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula acting as a string
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula acting as a string
Do you mean to say that you see the formula in the cell instead of the result?
How do you 'edit' the formula? "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula acting as a string
I experimented with this a bit more and found that the format of the
problematic cells change to text. If I change the format back to general, and retype the formula, it functions correctly. But why is the formatting changing ? Bill H "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula acting as a string
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula acting as a string
Sometimes, this is a useful feature.
If you have a formula that returns a date, for instance. Instead of seeing 39799, you'd see the date nicely formatted. 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help...my charts are acting up! | Charts and Charting in Excel | |||
worksheets acting perculiar... | Excel Discussion (Misc queries) | |||
Paste is acting up | Excel Worksheet Functions | |||
Text box acting as a notifier? | Excel Worksheet Functions | |||
SUMPRODUCT Acting Quirky | Excel Worksheet Functions |