| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I clear a formula?
I have a column that appears to have a formula in it. It is appears to
calculate figures for me automatically. How can I clear the formula out? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I clear a formula?
You use the word "appears" twice.
Is a cell with a formula nowhere to be found? If it can be found, select the cell with the formula and hit the "delete" button. I would look for a formula in any cell that gives me a total of other cells. If a formula cannot be found, perhaps some sheet event code? Right-click on the sheet tab and have a look. Gord Dibben MS Excel MVP On Sun, 18 May 2008 11:20:00 -0700, ManhattanRebel wrote: I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I clear a formula?
You are right. In my haste, I included the word "appears" twice, sorry about
that. Can you please tell me how I can keep the figure but remove the formula? "Gord Dibben" wrote: You use the word "appears" twice. Is a cell with a formula nowhere to be found? If it can be found, select the cell with the formula and hit the "delete" button. I would look for a formula in any cell that gives me a total of other cells. If a formula cannot be found, perhaps some sheet event code? Right-click on the sheet tab and have a look. Gord Dibben MS Excel MVP On Sun, 18 May 2008 11:20:00 -0700, ManhattanRebel wrote: I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I clear a formula?
Copy.
Edit/ Paste Special/ Values. -- David Biddulph "ManhattanRebel" wrote in message ... You are right. In my haste, I included the word "appears" twice, sorry about that. Can you please tell me how I can keep the figure but remove the formula? "Gord Dibben" wrote: You use the word "appears" twice. Is a cell with a formula nowhere to be found? If it can be found, select the cell with the formula and hit the "delete" button. I would look for a formula in any cell that gives me a total of other cells. If a formula cannot be found, perhaps some sheet event code? Right-click on the sheet tab and have a look. Gord Dibben MS Excel MVP On Sun, 18 May 2008 11:20:00 -0700, ManhattanRebel wrote: I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I clear a formula?
Another way:
Select the cell Hit F2 Hit F9 Hit Enter ManhattanRebel wrote: You are right. In my haste, I included the word "appears" twice, sorry about that. Can you please tell me how I can keep the figure but remove the formula? "Gord Dibben" wrote: You use the word "appears" twice. Is a cell with a formula nowhere to be found? If it can be found, select the cell with the formula and hit the "delete" button. I would look for a formula in any cell that gives me a total of other cells. If a formula cannot be found, perhaps some sheet event code? Right-click on the sheet tab and have a look. Gord Dibben MS Excel MVP On Sun, 18 May 2008 11:20:00 -0700, ManhattanRebel wrote: I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I clear a formula?
David, Thank you, that is exactly what I was looking for.
"David Biddulph" wrote: Copy. Edit/ Paste Special/ Values. -- David Biddulph "ManhattanRebel" wrote in message ... You are right. In my haste, I included the word "appears" twice, sorry about that. Can you please tell me how I can keep the figure but remove the formula? "Gord Dibben" wrote: You use the word "appears" twice. Is a cell with a formula nowhere to be found? If it can be found, select the cell with the formula and hit the "delete" button. I would look for a formula in any cell that gives me a total of other cells. If a formula cannot be found, perhaps some sheet event code? Right-click on the sheet tab and have a look. Gord Dibben MS Excel MVP On Sun, 18 May 2008 11:20:00 -0700, ManhattanRebel wrote: I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I clear a formula?
wonderful, thank you
is there any way to clear formulae in multiple cells at a time by this method? thanks in advance. "Dave Peterson" wrote: Another way: Select the cell Hit F2 Hit F9 Hit Enter ManhattanRebel wrote: You are right. In my haste, I included the word "appears" twice, sorry about that. Can you please tell me how I can keep the figure but remove the formula? "Gord Dibben" wrote: You use the word "appears" twice. Is a cell with a formula nowhere to be found? If it can be found, select the cell with the formula and hit the "delete" button. I would look for a formula in any cell that gives me a total of other cells. If a formula cannot be found, perhaps some sheet event code? Right-click on the sheet tab and have a look. Gord Dibben MS Excel MVP On Sun, 18 May 2008 11:20:00 -0700, ManhattanRebel wrote: I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out? -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I clear a formula?
Yes.
Highlight the cells you want to change. Right-click, Copy Right-click, Paste Special...ValuesOK Regards, Fred "Rod" wrote in message ... wonderful, thank you is there any way to clear formulae in multiple cells at a time by this method? thanks in advance. "Dave Peterson" wrote: Another way: Select the cell Hit F2 Hit F9 Hit Enter ManhattanRebel wrote: You are right. In my haste, I included the word "appears" twice, sorry about that. Can you please tell me how I can keep the figure but remove the formula? "Gord Dibben" wrote: You use the word "appears" twice. Is a cell with a formula nowhere to be found? If it can be found, select the cell with the formula and hit the "delete" button. I would look for a formula in any cell that gives me a total of other cells. If a formula cannot be found, perhaps some sheet event code? Right-click on the sheet tab and have a look. Gord Dibben MS Excel MVP On Sun, 18 May 2008 11:20:00 -0700, ManhattanRebel wrote: I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Clear a cell from within a formula | Excel Worksheet Functions | |||
| How to clear a value but not the formula? | Excel Discussion (Misc queries) | |||
| Clear cell from formula? | Excel Discussion (Misc queries) | |||
| Clear Contents But Not Formula | Excel Discussion (Misc queries) | |||
Linear Mode
