How do I get a cell to show the result instead of the formula?

Posted to microsoft.public.excel.worksheet.functions

harticd

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
My formula returns a result but the cell displays a zero?	Excel User	Excel Worksheet Functions	14	July 17th 08 08:49 PM
Can I make a formula in Excel to display result in same cell?	Neiko	Excel Worksheet Functions	2	October 1st 05 10:36 PM
Why does Excel show a formula in ONE cell ?	edpaul	Excel Discussion (Misc queries)	1	August 12th 05 07:29 PM
how to put a formula in one cell and the result in a another cell	mark	Excel Worksheet Functions	5	August 8th 05 02:59 AM
Cell shows formula and not the result of the formula.	stumpy1220	Excel Worksheet Functions	2	January 14th 05 05:11 PM

All times are GMT +1. The time now is 06:56 PM.

Menu

About Us