Larger minus smaller equals 0

[vintage36]

I am finding the differences between adjacent numbers in a column. All have been verified by ISNUMBER enquiry. The answer is always 0, no matter the format of the answer cell.

Please! Why this happening and what's the solution?

 

[mole999]

what is the formula you are using ?

 

[vintage36]

e.g in cell B2, =A2-A1. Such a calculation never given trouble before.

 

[mole999]

only thing i can think of is zero decimals and the numbers are so close that it ranges from -0.4 to 0.4

 

[vintage36]

Not so

[TABLE="width: 335"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]06/03/2018[/TD]
[TD]86758[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/04/2018[/TD]
[TD="align: right"]85989[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]03/05/2018[/TD]
[TD="align: right"]87275[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]03/06/2018[/TD]
[TD="align: right"]88604[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]27/06/2018[/TD]
[TD="align: right"]90256[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

Output cells are in general number format.

Unlikely I'd have thought; could it that I am still using a legacy version of Excel?

 

[vintage36]

I know what has caused the problem!
Originally the numbers were in another column and just copied over with a view to editing and re arranging. I did not use paste as values, where all works to order.

Thanks for trying to help.