Forum Discussion

Ivaylo_Bozhinov's avatar
Ivaylo_Bozhinov
Copper Contributor
Jul 02, 2020
Solved

Excel question

Hello,   I am using excel table. When I try to copy paste some numbers like 1000202610036 -> excel sheet is showing them as 1.00002E+12 . I would like to know what I need to do in order to present ...
microsoft 365
  • ExcelExciting's avatar
    ExcelExciting
    Jul 02, 2020

    Hi Ivaylo_Bozhinov 

     

    The default number format in Excel is General, therefore you can display up to 11 digits in a cell.

    So when you paste numbers length more than eleven (11) it truncate the value to scientific number.

    However you can change the formatting of the cell to numbers or text and then paste the value

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

ExcelExciting's avatar
ExcelExciting
MVP
Jul 02, 2020

Hi Ivaylo_Bozhinov 

 

The default number format in Excel is General, therefore you can display up to 11 digits in a cell.

So when you paste numbers length more than eleven (11) it truncate the value to scientific number.

However you can change the formatting of the cell to numbers or text and then paste the value

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

Resources