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"