This morning I was teaching a basic excel class using an older version
of Excel (probably 2000?)and had an embarrassing incident.
We were discussing how to use the fill handle to update formulas.  The
exact example is as follows:

First Name   Last Name   Column C
Anne           Lenhart         =B2&", "A2
Julie            Jones
Sarah          Evans

After we entered the formula in column c, I pulled the formula down
through the remainder of the column and although the formulas updated,
the values did not unless I went back and manually selected each cell.
Here I was, teaching, and I didn't know what was wrong!

Can anyone tell me how to fix this so next time I am in this situation
I don't embarrass myself?
Thank you,
Anne