I have two columns, one where I enter numbers and a second column where, for
some entries in the first column, I set the value equal to that in the first
colum. What is happening now is that when I enter a value into the first
column then the 'equals' is automatically entered into the 2nd column (eg,
in cell A30 I enter 20 and hit return, then Excel automatically inserts
"=A30" into cell B30 [where there was an "=A29" in cell B29]). I don't want
it to do this auto-complete, but it does, even though I've unchecked the
'auto-complete' box in the Settings menu. How do I stop it?

Thanks,
-Paul