'Microsoft Excel on save changes decimal point to 8

when i open on save excel the value displayed in excel is 596207726.09 but actual code behind value is 596207726.09000003.

why this change happaned?

But 596207726.09 in excel changed to 596207726.09000003 in code.

How 000003 getting added in code and how to solve the issue in c# code so it can take exact decimal point as given in Excel

For Example

  1. 596207726.09 - 596207726.09

  2. 596207726.092 - 596207726.092

c++sharpexceldecimalopenxml


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions