I tried adding a new column in the middle and it would not recalculate. I
added a new column at the end and it will recalculate. I got my project
done, but would still like to know why this happens...


"walark" wrote:

I am trying to add a column to a spreadsheet to change a text field from
yyyymmdd to mm/dd/yyyy. I have typed in the concatenation formula in the
formula help boxes and it displays the correct value there. When I exit out
of that back to the sheet it puts the formula in the box instead of the
value. Automatic calculation is set and I have tried F9. I also went thru the
formula error checking which showed no error and opened a watch window, which
shows my formula in the value box instead of the formula box. I have also
tried to change the formula from a concatenation based on a text field to a
simple sum based on two numeric fields (=G2 - H2) and that won't even
calculate. I've had this happen before and just gave up, but would like to
know why certain sheets just will not calculate.