View formula results instead of formula in 2003 version?

F

Felicia Pickett

In old Excel version 2002 you could use the CTRL+` to look at results instead
of a formula in the cell. That no longer works. How do you change it in Excel
2003?
 
G

Gord Dibben

With Excel 2003 CTRL + ` toggles View Formulas on/off same as Excel 2002.

If your formulas are not showing results but formulas only perhaps the cells
were formatted as text prior to entering the formulas.

Try selecting a cell with formula and re-formatting to General then(IMPORTANT)
hitting F2 then <ENTER>

Do you get the results now?

If so, do this for all the cells. If many cells, select them all then
Edit?Replace

What: =
With: =

Replace all.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 16:02:02 -0700, Felicia Pickett <Felicia
 
Top