Jason,

go to Tools | Options | Calculation (tab) and check that Calculation
mode is set to Automatic. It sounds like this has been set to Manual in
your sheet.

Hope this helps.

Pete

On Jan 26, 7:48 pm, Laviathn
wrote:
I have a degree in Finance and have been using Excel for many years now, but
came across an issue that I have never seen before and I am frustrated out of
my mind. I have two columns of different numbers formatted as general text. I
have entered a formula in a third column to add the two number of each line
of the first two columns (for example: =B25+C25). It adds the two up
correctly.

When I click the corner and drag the formul down the length of the two
columns to copy the formula, it displays the value of the first cell I am
dragging from, so all totals in the thrid colum show the same number! However
when I click on an individual cell, the formula is correct. (for example, 5
cells down: =B30+C30) But it still shows the calculated total from the first
cell I dragged from. It say it is adding up those two cells, but does not
show the correct total of the two!!! If I go to each cell in the thrid
column individually and enter the formula, it will calculate it correctly.
But if I change the value of either of the numbers in the first two columns,
it is not recalculating that third cell! It just stays the same.

If anyone out there has seen this or has any idea how this is possible, you
would be saving my mental health. All help is greatly appreciated!

Thanks,
Jason