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?

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?

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?

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?

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

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?

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

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