Exel 2003 Copy Formula Problem
 

I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only
copy the value that the original cells sum equals. Not the formula itself.
Format for cells is set as number.

Any suggestions?

Exel 2003 Copy Formula Problem
 

Check if your calc mode is set to Auto.

<Tools <Options <Calculation tab,

And make sure Auto is checked.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"addison" wrote in message
...
I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only
copy the value that the original cells sum equals. Not the formula itself.
Format for cells is set as number.

Any suggestions?

Exel 2003 Copy Formula Problem
 

I think it is probably copying the formula but sounds like calculation is set to
manual.

ToolsOptionsCalculationAutomatic.


Gord Dibben MS Excel MVP

On Wed, 12 Dec 2007 08:31:01 -0800, addison
wrote:

I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only
copy the value that the original cells sum equals. Not the formula itself.
Format for cells is set as number.

Any suggestions?

Exel 2003 Copy Formula Problem
 

That was it!

Thank you!

"Gord Dibben" wrote:

I think it is probably copying the formula but sounds like calculation is set to
manual.

ToolsOptionsCalculationAutomatic.


Gord Dibben MS Excel MVP

On Wed, 12 Dec 2007 08:31:01 -0800, addison
wrote:

I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only
copy the value that the original cells sum equals. Not the formula itself.
Format for cells is set as number.

Any suggestions?

Exel 2003 Copy Formula Problem
 

That was the problem!

Thank you!

"RagDyeR" wrote:

Check if your calc mode is set to Auto.

<Tools <Options <Calculation tab,

And make sure Auto is checked.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"addison" wrote in message
...
I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only
copy the value that the original cells sum equals. Not the formula itself.
Format for cells is set as number.

Any suggestions?