View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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.