Could be you have changed the numerics to text.

Format all to General then copy an empty cell.

Select the range of numerics and EditPaste SoecialAddOKEsc.


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 03:34:04 -0800, Louise
wrote:

I have been compiling a spreadsheet today which involves numerous simple
formulas which add up the contents of various cells. Everything was going
well but now suddenly every formula I enter returns a 0.00 result in the
cell. I've checked my formulas which are correct and I dont receive any
error messages. This happened after I had edited some of my figures and cut
out some of the rows of figures. After I had made these edits, I edited the
formula to remove the cells which I didnt want to include in my sum and now
every single formula, including the auto total function returns a zero. Does
anyone have any idea why this has occurred and how I can fix it? This is the
second time this has happened this week! Many thanks