What to do when your Formula is Showing in Excel Instead of Value
1. worksheet is set to display formula and not results. Hold down the CTRL and tap `
2. Double check the cell value to see if a quote or character exists before the formula “=A1”. The correct formula is =A76 note there are no quotes.
3. Ensure the cell is formatted as text. Select the cell, right click, format cells and select ‘general’. Now tap F2 and enter.