Why do I sometimes get a return of -1,4209E and so on.

Fredrik Söderholm Pettersson 81 Reputation points


Sometimes I get a return of -1,4209E and similar to this to a simple subtraction and I cant't figure out why. Amount is the sum I get from a puchase order from our NAV And Summa OC is extracted from a PDF file.

What is strange is that it's only on a few rows.

Can it perhaps be some hidden characthers the needs to be cleaned in Summa OC from the PDF?


Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,988 questions
No comments
{count} votes

Accepted answer
  1. Nazer Mohamed 76 Reputation points

    It is possible that the "Amount" or "Summa OC" has some decimal values (eg: 1,000000000000000004) that are rounded off. But the next column does not round off...

    So you have two options here

    1. easy fix -> format the "Diff Summa" as Number with One decimal place.
    2. Force the decimals in "Amount" and "Summa OC" by using ROUND()


    No comments

1 additional answer

Sort by: Most helpful
  1. Fredrik Söderholm Pettersson 81 Reputation points

    Hello Mohamed.

    I used the #1 option, the easy fix and it worked perfectly.

    Thank you very much :)

    Best Regards Fredrik

    No comments