10 decimal place numbers not adding/subtracting exactly

[Mark McInerney]

Hi Folks,

I have some data stored in columns where the numbers have 10 decimal places - when I subtract the numbers it is not allowing for the decimal places and I need the result to be exact?

In the below example I need the result to be -200.0000000160 when I subtract 0, and not -200.0000000000

Thanks - Mark.

 

[Cubist]

What does it return when you do =A1 =C1? Comparing the original to the result cell.

 

[Mark McInerney]

They come back exactly as they are entered - all decimal places are OK.

 

[Cubist]

It should've returned TRUE or FALSE. Please read my question again.

 

[Mark McInerney]

It comes back FALSE

 

[Cubist]

What about =ABS(A1) = ABS(A2)

 

[Mark McInerney]

#value!

 

[Joe4]

This seems very odd. Is there any chance you could upload a copy of your worksheet (removing any sensitive data first, of course) to a file sharing site and provide a link to it here so we can download it and investigate it for ourselves?

 

[Mark McInerney]

Hi Joe4,

Apologies - just after seeing this message - Thanks for having a look at this for me - I am no longer working on the data. Thanks again.