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.