Make sure calculation is set to automatic...

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"Bojamin" wrote in message
...
I have a simple formula and my cells are all formatted as general, but when
I
copy the formula down several cells, the values do not chnage, they stay
the
same as the first cell. When clicking on the function helper (Fx), the
info
returned is correct, but it shows up in the cell incorrectly.

For example:

formula =CONCATENATE(A1,".",B1)
Joe (A1), Smith (B1), results in Joe.Smith

But when I copy the formula down, i still get Joe.Smith returned, when it
should be Sue.Jones

formula =CONCATENATE(A2,".",B2)
Sue (A2), Jones (B2), results in Joe.Smith

However, when I click on the "Fx" by the formula bar, the dialog that pops
up shows the results of the formula accurately, i.e. "Sue.Jones"