| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula displayed instead of value of formula
when i type in a formula, say =QUOTES!A18, it is displayed as =QUOTES!A18
instead of the value of cell A18 in the sheet named QUOTES. what am i doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula displayed instead of value of formula
Select Tools/Options from Excel's menu bar, click the View tab on the dialog
box that appears and see if there is a check mark in the Formulas CheckBox in the "Window options" section. If so, uncheck it. Rick "des-sa" wrote in message ... when i type in a formula, say =QUOTES!A18, it is displayed as =QUOTES!A18 instead of the value of cell A18 in the sheet named QUOTES. what am i doing wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula displayed instead of value of formula
was the cell formatted as text before the formula was entered. If so delete it format as general and enter again Mike "des-sa" wrote: when i type in a formula, say =QUOTES!A18, it is displayed as =QUOTES!A18 instead of the value of cell A18 in the sheet named QUOTES. what am i doing wrong? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula displayed instead of value of formula
thanks so much, stupidity ruled!
"Mike H" wrote: was the cell formatted as text before the formula was entered. If so delete it format as general and enter again Mike "des-sa" wrote: when i type in a formula, say =QUOTES!A18, it is displayed as =QUOTES!A18 instead of the value of cell A18 in the sheet named QUOTES. what am i doing wrong? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula displayed instead of value of formula
1. You are in "formula view". Hit CTRL + `(above Tab key)
2. The cell was pre-formatted as Text. Format to General then F2 and ENTER Gord Dibben MS Excel MVP On Sun, 22 Jun 2008 11:57:00 -0700, des-sa wrote: when i type in a formula, say =QUOTES!A18, it is displayed as =QUOTES!A18 instead of the value of cell A18 in the sheet named QUOTES. what am i doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula is displayed instead of the result | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| Formula is displayed, not result | Excel Worksheet Functions | |||
![des-sa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
