Formula Problem
 

When I drag and drop a formula it is copying the cells only and not the
result, however when I go into the cell and press enter the result is
correct.

Tools|Options|Calculate
If Manual is checked, change it to Automatic.

Jerry

Tracey BVS wrote:

When I drag and drop a formula it is copying the cells only and not the
result, however when I go into the cell and press enter the result is
correct.

Hi
goto 'Tools - Options - Calculate' and enable 'Automatic calculation'

--
Regards
Frank Kabel
Frankfurt, Germany

"Tracey BVS" <Tracey schrieb im
Newsbeitrag ...
When I drag and drop a formula it is copying the cells only and not
the
result, however when I go into the cell and press enter the result is
correct.