Integer truncation in Excel

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • pankajit09
    Contributor
    • Dec 2006
    • 296
    #1

    Integer truncation in Excel

    The maximum digit without truncation is 15 in EXCEL.

    How to avoid this truncation ?
    Tags: None
    • Stang02GT
      Recognized Expert Top Contributor
      • Jun 2007
      • 1206
      #2
      Originally posted by pankajit09
      The maximum digit without truncation is 15 in EXCEL.

      How to avoid this truncation ?
      If the max is 15, then that is something you cannot avoid. If excel has a limit to something then there is probably a good reason why.

        Comment

        • pankajit09
          Contributor
          • Dec 2006
          • 296
          #3
          Originally posted by Stang02GT
          If the max is 15, then that is something you cannot avoid. If excel has a limit to something then there is probably a good reason why.

          One of the ways is to make the cell as "text".
          Then it will accept huge numbers.

          Is there any other way ?

            Comment

            Previous template Next
            Working...