Forum Discussion

S_conroy860's avatar
S_conroy860
Copper Contributor
Feb 28, 2019

Excel newb

I’m trying to copy a number with 16+ digits into a cell and it keeps giving me a weird 6.2936738299 result and it shortens the number when I double click. How do I stop this madness??!
excel
Formulas and Functions

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 28, 2019

    Hi,

     

    Excel maximum number of digits in a cell is 15.

    Please check out this https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 under Calculation specifications and limits table.

     

    Here's https://www.sageintelligence.com/tips-and-tricks/2017/09/work-numbers-containing-15-digits-excel/.

     

    Hope that helps