Formula is right but value is wrong! Makes no sense!

[Astello]

I'm trying to take 2 columns: 1 with a city name in it, and 1 with a
state abbreviation in it, and put them together using this worksheet
function:

=AB5&", "&AC5

This takes the two and puts a comma between them, for example:

AB AC Turns into: "Jonesville, MO" in column AD.
Jonesville MO



I've been using the method where I double click in the bottom-right
corner of the cell to paste the formula all the way down the
spreadsheet, and it has worked fine on 20 other spreadsheets. But in
this particular spreadsheet, the values from the first cell get copied
all the way down. The formulas are right, as in they point to cells
with different values, but the same city name and state abbrev. shows
up for each one. I've tried everything to correct this. Please help!

Here is a screenshot, notice the formula, and then the value - they
don't match up

http://i25.photobucket.com/albums/c91/astello929/excelmess.jpg

 

[dgp]

My only guess is that Excel's calculation option is set to Manual
rather than Automatic?

Hit the F9 key to see if the formulas update to the correct values. If
this works you can change the calculation setting to Automatic:

Go to Tools>Options
Click the Calculation tab
In the Calculation section, select Automatic