Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
E2007 formulas display as formulas, not results
Entering a simple formula such as =AB1 into a cell results in =AB1
displayed. Formulas don't work either. Why would that be? Calculation is set to automatic, and formulas are set to display results. The supplied source data section of the sheet is the section of the sheet which will not display the results. However, another section of the same worksheet behaves fine by displaying formula results in their cells. Something about the properties of the source data? It all looks like text. Calculations, are not displayed properly in that area of the sheet. TIA for ideas. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up Formulas with Results | Excel Discussion (Misc queries) | |||
Display results of formulas | Excel Worksheet Functions | |||
Display results of formulas not the actual formula | Excel Discussion (Misc queries) | |||
can I use 2 formulas in 1 cell and display both results | New Users to Excel | |||
Formulas with If/ and results | Excel Worksheet Functions |