Home |
Search |
Today's Posts |
#1
|
|||
|
|||
View formula results instead of formula in 2003 version?
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? |
#2
|
|||
|
|||
I think you've got it backwards, but... it still works for me.
************ Anne Troy www.OfficeArticles.com "Felicia Pickett" <Felicia wrote in message ... 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? |
#3
|
|||
|
|||
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 wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some formula results will not show up in the cell | Excel Worksheet Functions | |||
can I use GO TO results in a formula? | Excel Worksheet Functions | |||
Excel 2003 - cells in formula? | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Office 2003 will not view interactive Worksheet saved as a web pa. | Excel Worksheet Functions |