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.
|