How come my formula appears in the cell instead of the value of the formula?
B Bernie Deitrick Jul 1, 2004 #2 Cheryl, 1) You are entering a formula into a cell formatted for text. Format the cell for General, then re-enter the formula 2) You are viewing formulas - use Tools | Options | View tab, uncheck Formulas (under Window options). HTH, Bernie MS Excel MVP
Cheryl, 1) You are entering a formula into a cell formatted for text. Format the cell for General, then re-enter the formula 2) You are viewing formulas - use Tools | Options | View tab, uncheck Formulas (under Window options). HTH, Bernie MS Excel MVP
