Instead of the result of a formula showing up in the cell, the formula itself is displayed.
C carpfish Jul 5, 2006 #1 Instead of the result of a formula showing up in the cell, the formula itself is displayed.
C Chip Pearson Jul 5, 2006 #2 Does this happen to all formulas or just one? The cell is likely formatted as Text. Change the format to General and then select the cell. Press F2 then Enter. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Does this happen to all formulas or just one? The cell is likely formatted as Text. Change the format to General and then select the cell. Press F2 then Enter. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
D Die_Another_Day Jul 5, 2006 #3 sounds like you either forgot the "=" in front of your formula or it is formatted as text HTH Die_Another_Day
sounds like you either forgot the "=" in front of your formula or it is formatted as text HTH Die_Another_Day
M Marcelo Jul 5, 2006 #4 HI tools | options | view | Formula hth regards from Brazil Marcelo "carpfish" escreveu:
