On Jan 14, 11:02*am, Pierre wrote:
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

It display your formulas cause your cell format is probably set to
TEXT. Change it to GENERAL and retype your formulas. Should do the
trick!