| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a cell to show the result instead of the formula?
I have gone to Tools - Options and formulas are unchecked. However, I
cannot get one particular cell to display results. It will only display formulas. For example, if I simply reference another cell in the sheet, the "=A1" reference shows up rather than the value of cell A1. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get a cell to show the result instead of the formula?
Hi
The cell is formatted as text. Format it as General (or number, or date) and re-enter the formula (activate the cell, press F2, and then Enter) Arvi Laanemets "harticd" wrote in message ... I have gone to Tools - Options and formulas are unchecked. However, I cannot get one particular cell to display results. It will only display formulas. For example, if I simply reference another cell in the sheet, the "=A1" reference shows up rather than the value of cell A1. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get a cell to show the result instead of the formula?
Try this:
Select the cell FormatCellsNumber tab Category: General (it's probably set to Text right now) Click the [OK] button. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "harticd" wrote: I have gone to Tools - Options and formulas are unchecked. However, I cannot get one particular cell to display results. It will only display formulas. For example, if I simply reference another cell in the sheet, the "=A1" reference shows up rather than the value of cell A1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My formula returns a result but the cell displays a zero? | Excel Worksheet Functions | |||
| Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
| Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
| how to put a formula in one cell and the result in a another cell | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Linear Mode
