View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default 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