This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi all,
I've a strange one here. If I copy from notepad the following numbers into Excel in column A, then perform a formula (=A2-A3) which subtracts the number below from the number above I get all these crazy numbers before the decimal place.....
The formatting is the same in every cell.
What gives?
thanks
Dave
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
OK. Understood. This is floating point arithmetic at work. To handle this in your CF or anywhere else, you will need to use ROUND formula.
Read here, you will understand this - https://www.microsoft.com/en-us/microsoft-365/b...
Can you give me an example of a problem cell? Let me pick up one.
In C3 you have 22.95 which came because of the formula B2-B3.
B2 = -8033.88 and B3 has -8010.93
B2-B3 = -8033.88 - (-8010.93) and answer would be 22.95 which is correct.
If you can give me an example where the result is not as per your expectation that would make me to solve the issue for you.
B2 is actually -22.949999999....
This is the problem, it should just be -22.95