Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula, not the result is displayed in calculated cells - why?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula, not the result is displayed in calculated cells - why?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula is displayed instead of the result | Excel Discussion (Misc queries) | |||
formula displayed, not calculated | Excel Discussion (Misc queries) | |||
formula result not displayed | Excel Discussion (Misc queries) | |||
Formula is displayed, not result | Excel Worksheet Functions | |||
formula displayed instead of the result ??? | Excel Worksheet Functions |