Sometimes when I enter a formula in Excel, it displays the text of the formula instead of the results. Once this happens I can't get it to display correctly. Is this a bug in Excel 2003, or have I inadvertently changed some obscure setting somewhere to display the actual formula instead of the result? If so, how do I change it back?
Simplified example:
Contents of cell A7: 000114 (Account number formatted as text)
Formula in cell b7: =A7
Contents of cell B7 displays "=A7" instead of "000114"
Simplified example:
Contents of cell A7: 000114 (Account number formatted as text)
Formula in cell b7: =A7
Contents of cell B7 displays "=A7" instead of "000114"