decimals formating

Hi, I have this problem with my excel in general: above sum should be 0. All decimals are exactly 2. Is there something i can correct in the formatting in my excel? Thank you in advance for your help.

Hello, guys! I'm trying to covert a column full of numbers like 1234,56 or 987.654 to this format 1234.56, max 2 decimals and "." instead of ",". But when I try to find the "," the method completely ignores it... I tried to change the format from General to Numbers, Text etc., but no success...

Hi: I have data that look like this (Current Data); and I want to change it to a format like the next column("Needed"): <tbody> <tbody> Current Data Needed 0.082 8.2 7.2 7.2 0.065 6.5 7.2 7.2 0.066 6.6 6 6.0 </tbody> </tbody> Just to give a background, this is a lab value...