AutoFill w/formulas
 

I have three columns of data B1, C1, D1 which I concatenate into a fourth
column E1. Then I need to use the autofill function in the fourth column do
autofill the formula on all rows below the initial cells.

What is happening is that on each subsequent row, it is actually copying the
data in cell E1 down through each cell. However, when I click on one of the
cells and look in the formula bar, the formula is correct but the resulting
data is not.

Am I doing something here?

Maybe you have calculation set to manual under toolsoptionscalculation,
set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please)


"JamesElting" wrote in message
...
I have three columns of data B1, C1, D1 which I concatenate into a fourth
column E1. Then I need to use the autofill function in the fourth column
do
autofill the formula on all rows below the initial cells.

What is happening is that on each subsequent row, it is actually copying
the
data in cell E1 down through each cell. However, when I click on one of
the
cells and look in the formula bar, the formula is correct but the
resulting
data is not.

Am I doing something here?