Formula, not the result is displayed in calculated cells - why?
It sounds like that sheet is set to display formulas, instead of their results.
Try this:
From the Excel Main Menu:
<tools<options<view tab....UNcheck: Formulas
Click [OK]
Or....the keyboard shortcut for that: Ctrl+ `
(The ` is on the key above the [Tab] key)
Does that help?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Michelle" wrote in message ...
When I enter in any formulas on a Hyperion derived spreadsheet, the formula,
not the result, is displayed in the cells - Like adding 2 cells looks like:
=SUM(L9:L10)
Not the answer it should be.
|