I'm going crazy, Excel returns 0 for a simple sum

E

Eric

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?
 
G

Gord Dibben

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 Edit>Paste Special(in place)>Add>OK>Esc


Gord Dibben MS Excel MVP
 
E

Eric

Turns Out I had a circular referance in one of the squares i was trying to
sum. Thank you for your help.
 
G

Gord Dibben

Thanks for letting us know what the solution turned out to be.

By the way.............those "squares" are commonly known as "cells"


Gord
 
Top