Thanks Roger, that was it.

--
Traa Dy Liooar

Jock


"Roger Govier" wrote:

Hi Jock

It sounds as though the cell has been pre-formatted as Text.
Try FormatCellsNumberGeneral
then enter your formula

If it still shows as the formula, as opposed to the result, then you have
the Toggle set to Display Formulas
Press the Control button + ` (the key to the left of number 1 on the top
row of the keyboard)

This toggles the mode between displaying formulas, and displaying the
results of formulas.
--

Regards
Roger Govier

"Jock" wrote in message
...
When I put this in a cell:
=IF(C8="","",B7+1)
it is displayed exactly as typed rather than acting as a formula (which it
is).
This has happened to me in the past on other spreadsheets, and I managed
to
fix the issue by copying (dragging) a similar formula from an adjacent
cell.
What is going on??
--
Traa Dy Liooar

Jock