Excel column formula inexplicably skips a cell

[dareys]

Greetings,

As you will see in the below spreadsheet I havve a formula for column K (which is the same as column J) that does not calculate correctly.

Column J adds up fine, column K does not...

I would appreciate some help with this.

Thank you.

Jean-Pierre

[#2]

@dareys 

What is the result of ISNUMBER(K3)?

[#3]

Hello Detief,
I pasted the data into the cell, it looked like a number, it was not.... Thank you for your help.
Jean-Pierre