On Sat, 09 Jan 2010 09:02:35 -0600, Dave Peterson
wrote:

Look at the formulas in those cells again. If the formulas adjusted, but the
value displayed in the cell hasn't changed, then there's a good chance you have
manual recalculation set.

In xl2003 menus:
tools|options|calculation tab
check automatic.

This setting is picked up from the first workbook you open in that session. You
may want to remember how to toggle it.

Thanks for the reply.

Recalculation was set to automatic.

I seem to have it sorted out now - after I enetered the formula in the
first cell I then changed the file to "hide formulae" and then just
pulled the cell downwards by holding down the little "handle" on the
botom rh side of the cell.

This got the fomulae to repeat and change as I scrolled down.

B.N.