Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hidden results
hello,
in one complex Excel 2003 application some formulas stopped to show their results. Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10)) the formula remains written instead of disappearing and formatted like if a conditional formatting should be applied to the cell. Thanks, Emiliano |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hidden results
On Mar 25, 2:21*pm, "eggpap" wrote:
hello, in one complex Excel 2003 application some formulas stopped to show their results. Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10)) the formula remains written instead of disappearing and formatted like if a conditional formatting should be applied to the cell. Thanks, Emiliano Check that the cell is formatted to "General" ... not "Text" - you could try hitting F9 (re-calculate), if the first didn't work. Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hidden results
Check your other post, too.
eggpap wrote: hello, in one complex Excel 2003 application some formulas stopped to show their results. Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10)) the formula remains written instead of disappearing and formatted like if a conditional formatting should be applied to the cell. Thanks, Emiliano -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying results in formula bar when cell is hidden | Excel Discussion (Misc queries) | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
Pivot Table - data results that equal zero to be hidden | Excel Programming | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |