SOLVED

Excel question

%3CLINGO-SUB%20id%3D%22lingo-sub-1502655%22%20slang%3D%22en-US%22%3EExcel%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502655%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20excel%20table.%20When%20I%20try%20to%20copy%20paste%20some%20numbers%20like%201000202610036%20-%26gt%3B%20excel%20sheet%20is%20showing%20them%20as%201.00002E%2B12%20.%20I%20would%20like%20to%20know%20what%20I%20need%20to%20do%20in%20order%20to%20present%20the%20number%20as%20the%20initial%20value%20of%201000202610036%20.%20What%20option%20needs%20to%20be%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOffice%20version%201808%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3EIvaylo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1502655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1502787%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502787%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F716602%22%20target%3D%22_blank%22%3E%40Ivaylo_Bozhinov%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20d%3CSPAN%3Eefault%20number%20format%20in%20Excel%20is%20General%2C%20therefore%20you%20can%20display%20up%20to%2011%20digits%20in%20a%20cell.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22inherit%22%3ESo%20when%20you%20paste%20numbers%20%3C%2FFONT%3Elength%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3Bmore%20than%20eleven%20(11)%20it%20truncate%20the%20value%20to%26nbsp%3B%3C%2FFONT%3Escientific%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3Bnumber.%3C%2FFONT%3E%3C%2FP%3E%3CP%3EHowever%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3Byou%20can%20change%20the%20%3C%2FFONT%3Eformatting%3CFONT%20face%3D%22inherit%22%3E%26nbsp%3Bof%20the%20cell%20to%20numbers%20or%20text%20and%20then%20paste%20the%20value%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 the number as the initial value of 1000202610036 . What option needs to be done.

 

Office version 1808

 

Best Regards,

Ivaylo

1 Reply
Best Response confirmed by Ivaylo_Bozhinov (New Contributor)
Solution

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