"NicciS" wrote:
.. when I enter formula's, the cells
won't display the values just the formula.

From the above line, one other guess is that the cells may have been
inadvertently pre-formatted as Text. Try selecting the entire sheet (or
just the col) and re-format as say: General. Then just re-confirm the
formula in the starting cell (click inside the formula bar and press ENTER)
and copy down/across, etc. That should get it going.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--