Michelle

You could be in Formula View.

Hit CTRL + `(backquote above Tab key) to toggle in/out of formula view.

Or.....my money's on this...........the cells were pre-formatted as text.

Format all to General then F2 and ENTER to re-enter the formula.

BTW.........don't need the SUM function for every occasion.

=L9+L10 will suffice.


Gord Dibben MS Excel MVP


On Sun, 28 Oct 2007 09:03:01 -0700, Michelle
wrote:

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.