auto sum not working

[juster21]

i have 10 cells that i am trying to use auto sum on and the result is 0. it should be something besides 0....any ideas what is going on?

 

[Joe4]

juster,

I have never seen a situation where the Text to Columns solution did not fix the problem. If you PM me, I can give you an email address that you can send the file to and I can take a look at it tonight after work.

By the way, how did these cells get populated in the first place. Where the numbers manually typed in or were they Cut and Pasted from somewhere?

 

[juster21]

i have the number 81 in cell e2. if i go to any other cell and type

=e2

and hit enter...that cell shows 0.


also, i can go to any cell and type =2+3+4 and the answer shows as 0.

 

[Andrew Poulsom]

What is the number format of the cell that shows 0 when you enter =2+3+4? I can reproduce your problem if it's eg "0";"0".

 

[juster21]

the format is number. strange thing is that if i send the worksheet to someone else, it works fine for them, and when they send it back it works fine for me. But this is the second time that i've open the workbook and had this problem.

todays problem was a little different than last time since today i created a new sheet.