Sounds like the data is text.

In a spare column enter =ISNUMBER(cellref) and copy down.

Do you get a return of FALSE?

Simply formatting to number will not change text data to a number.

You must coerce the data to become numeric.

Format all as General.

Copy and empty cell.

Select the data range and EditPaste Special(in place)AddOKEsc


Gord Dibben MS Excel MVP

On Sun, 24 Sep 2006 15:14:06 -0700, Eric wrote:

all i am trying to do is add j82 and k82 excel is returning a value of 0.
First i thought the formula was incorrect =j82+(k82/100) but that was not it.
Next i check the format of what's being added, they were all set to number,
no problem there. Next I Evaluate Formula this is where i am losin my mind it
steps me through the process
=J82+(K82/100)
=12243+(K82/100)
=12243+(72/100)
=12243+(0.72)
=12242+0.72
=0.00
There is no error sign nothing. Can any one help?