if I enter text or number in a cell say A1 then enter =A1 in cell B1 b1 only
displays the formula =A1 and does not bring the value in. Tools options
calculation is set to automatic. F9 has no effect ctrl alt f9 does not work
- any ideas