Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   by increasing indent in excel with seventh digit shows integer (https://www.askmehelpdesk.com/showthread.php?t=676653)

  • Jun 29, 2012, 12:36 AM
    soujanyaum
    by increasing indent in excel with seventh digit shows integer
    In excel if I increase the indent more than 7 decimal digits showing the value: 55156180.4400003000000
    but with increasing the indent to only 6 digits shows:55156180.440000

    What could be the reason and how to resolve this issue.
    Request any suggestions.
  • Jul 2, 2012, 10:51 PM
    JBeaucaire
    I don't understand the problem.

    IF the number is 55156180.4400003000000 and you format that to 6 decimals, the rounding results in 55156180.440000 because the 3 in the 7th decimal isn't high enough to cause it to round up.

  • All times are GMT -7. The time now is 05:27 AM.