Hi Everyone,

Can you help me please.
I have a column of numbers. I have formated the cells as number but when I
try to sum() the column it does not calculate, it just leaves the words
Sum() in the cell. Also any cells with zero in them display as 0 and not
0.00 it's as if the contents of the cells are still text but I have
formatted to number.

Does anyone know what's going on and how I get over this.

Thanks for your help it's appreciated.

Best Regards,

Steve Wilson.