Adding more than 15 digits in Excel












11















I want to add more than 20 digits in an Excel cell.



The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I enter more than 15 digits it gets converted to 0's.



What are the recommended steps for stopping Excel from converting data to exponential Format for 20 digits when in the general format?




Example: 12345678901234567890




Excel converts it to 1.23457E+19 in general format.



Without using ' before the value, is there any other way to keep value same?










share|improve this question

























  • I used to work on financial app. I had to store a product of 8 digits x 8 digits temporarily while calculating. 8 digit is not that uncommon, right?

    – Kenji Noguchi
    May 29 '13 at 11:54











  • Please tell us the reason why you need to do this. It sounds like an XY problem

    – Jan Doggen
    Oct 27 '14 at 11:24











  • There is no other way in the current version of excel.

    – Firee
    Feb 22 '16 at 12:06











  • It's still the same issue in Excel 2016 !!

    – Pirate X
    Feb 21 at 11:09
















11















I want to add more than 20 digits in an Excel cell.



The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I enter more than 15 digits it gets converted to 0's.



What are the recommended steps for stopping Excel from converting data to exponential Format for 20 digits when in the general format?




Example: 12345678901234567890




Excel converts it to 1.23457E+19 in general format.



Without using ' before the value, is there any other way to keep value same?










share|improve this question

























  • I used to work on financial app. I had to store a product of 8 digits x 8 digits temporarily while calculating. 8 digit is not that uncommon, right?

    – Kenji Noguchi
    May 29 '13 at 11:54











  • Please tell us the reason why you need to do this. It sounds like an XY problem

    – Jan Doggen
    Oct 27 '14 at 11:24











  • There is no other way in the current version of excel.

    – Firee
    Feb 22 '16 at 12:06











  • It's still the same issue in Excel 2016 !!

    – Pirate X
    Feb 21 at 11:09














11












11








11


5






I want to add more than 20 digits in an Excel cell.



The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I enter more than 15 digits it gets converted to 0's.



What are the recommended steps for stopping Excel from converting data to exponential Format for 20 digits when in the general format?




Example: 12345678901234567890




Excel converts it to 1.23457E+19 in general format.



Without using ' before the value, is there any other way to keep value same?










share|improve this question
















I want to add more than 20 digits in an Excel cell.



The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I enter more than 15 digits it gets converted to 0's.



What are the recommended steps for stopping Excel from converting data to exponential Format for 20 digits when in the general format?




Example: 12345678901234567890




Excel converts it to 1.23457E+19 in general format.



Without using ' before the value, is there any other way to keep value same?







microsoft-excel-2003






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 11 '13 at 10:43









Peter Mortensen

8,376166185




8,376166185










asked Jan 3 '12 at 4:38









user111921user111921

56124




56124













  • I used to work on financial app. I had to store a product of 8 digits x 8 digits temporarily while calculating. 8 digit is not that uncommon, right?

    – Kenji Noguchi
    May 29 '13 at 11:54











  • Please tell us the reason why you need to do this. It sounds like an XY problem

    – Jan Doggen
    Oct 27 '14 at 11:24











  • There is no other way in the current version of excel.

    – Firee
    Feb 22 '16 at 12:06











  • It's still the same issue in Excel 2016 !!

    – Pirate X
    Feb 21 at 11:09



















  • I used to work on financial app. I had to store a product of 8 digits x 8 digits temporarily while calculating. 8 digit is not that uncommon, right?

    – Kenji Noguchi
    May 29 '13 at 11:54











  • Please tell us the reason why you need to do this. It sounds like an XY problem

    – Jan Doggen
    Oct 27 '14 at 11:24











  • There is no other way in the current version of excel.

    – Firee
    Feb 22 '16 at 12:06











  • It's still the same issue in Excel 2016 !!

    – Pirate X
    Feb 21 at 11:09

















I used to work on financial app. I had to store a product of 8 digits x 8 digits temporarily while calculating. 8 digit is not that uncommon, right?

– Kenji Noguchi
May 29 '13 at 11:54





I used to work on financial app. I had to store a product of 8 digits x 8 digits temporarily while calculating. 8 digit is not that uncommon, right?

– Kenji Noguchi
May 29 '13 at 11:54













Please tell us the reason why you need to do this. It sounds like an XY problem

– Jan Doggen
Oct 27 '14 at 11:24





Please tell us the reason why you need to do this. It sounds like an XY problem

– Jan Doggen
Oct 27 '14 at 11:24













There is no other way in the current version of excel.

– Firee
Feb 22 '16 at 12:06





There is no other way in the current version of excel.

– Firee
Feb 22 '16 at 12:06













It's still the same issue in Excel 2016 !!

– Pirate X
Feb 21 at 11:09





It's still the same issue in Excel 2016 !!

– Pirate X
Feb 21 at 11:09










11 Answers
11






active

oldest

votes


















13














Some numbers are displayed in exponential format if the column is too narrow and you can fix this by increasing the width of the column.



However, very large numbers in Excel are stored in floating point format and cannot be represented in Excel exactly. You may be able to override their display using cell formatting but the true values will still be stored and processed using floating point arithmetic, with its inherent limitations.



If you need to perform calculations with greater precision you need an application that supports arbitrary precision arithmetic.






share|improve this answer
























  • By increasing width of column also number format in exponential only

    – user111921
    Jan 3 '12 at 5:04











  • @user111921, correct. If the number is very large it is stored in floating point format and must be displayed in exponential form, no matter how wide the column is.

    – Mike Fitzpatrick
    Jan 3 '12 at 5:14











  • NUmber format is normal number there is no floating point.For normal number range after 15 digits value the value is changes to exponential format

    – user111921
    Jan 3 '12 at 5:19






  • 1





    @user111921, correct. If you enter a large integer into Excel it will be converted to floating point (with some loss of precision) and displayed in exponential form. It is unavoidable in Excel and most other applications unless they specifically support arbitrary precision arithmetic.

    – Mike Fitzpatrick
    Jan 3 '12 at 5:23











  • To be precise, Excel 2010 doesn't support integers with more than 10 digits. Enter a number with 11 digits, or enter 9,999,999,999 and add one to it in a formula, and you end up with a floating point number. You can format it as an integer, but you still your low digits will be lost to rounding error.

    – Isaac Rabinovitch
    Oct 8 '12 at 4:48



















6














When you don't need to calculate with these numbers, you can treat them as text, see the other answers.
When you need to calculate with them, then it becomes difficult because Excel has only 15 siginificant digits. The possibilities I know are:




  1. Split the number in 2 (or more) cells. Put a part of the number in
    one cell and the remainder in another cell. The consequence is that
    you need to develop your own formules for calculations.


  2. Another solution is using add-in's. For a free one study the articles mentioned in http://www.excel-ticker.com/calculation-of-very-large-numbers-in-excel-part-5-add-in/







share|improve this answer































    4














    The reason is the limited precision that can be stored in a floating point variable. For a complete explanation you should read the paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic", by David Goldberg, published in the March, 1991 issue of Computing Surveys.



    Another, more accessible site, is Chip Pearson's site.



    In Excel, the floating point type is Double which is a IEEE 64-bit (8-byte) floating-point number. These can display 15 digit precision (well sort of, see the MSDN article Excel Worksheet and Expression Evaluation).






    share|improve this answer

































      0















      1. just copy your number from the cell

      2. format another cell(where to copy-destination cell) as text

      3. double click on the destination cell and paste in it.






      share|improve this answer

































        0














        I had to have a large number in order to create a unique number for a website.



        In the end I created the large numbers by using concatenate to add cells together. Example:



        OL  2890000000  0000004 OL28900000000000004
        OL 2890000000 0000005 OL28900000000000005
        OL 2890000000 0000006 OL28900000000000006
        OL 2890000000 0000007 OL28900000000000007
        OL 2890000000 0000008 OL28900000000000008





        share|improve this answer

































          0














          You might be able to solve the issue with these two steps:



          1) Seperate the numbers into as many columns as necessary. Make sure the format is TEXT.



          2) Use FORMULA>TEXT>CONCATENATE to combine the columns into one column and you should get your desired result.



          In any case that you need to do so for running numbers like serial numbers for example, seperate the numbers and run them down in GENERAL format first, then combine.






          share|improve this answer































            0














            I had the same issue with barcodes that I was pulling from a database, the solution that worked best for me is to pass the number to excel as a formula that displays text.



            For example, instead of passing just the barcode, I was passing ="barcode" so that excel interprets as a string a shows the whole number without any other characters as in the ' solution. This way you can copy and paste the number easily.



            Here's my SQL function:



            ALTER function [dbo].[ConvertBarcode](@BARCODE varchar(40))
            returns varchar(40)
            as
            begin
            return '="'+@BARCODE+'"'
            end


            Happy coding!






            share|improve this answer































              0














              You can correctly store the 15 most significant digits of an integer in Excel (my version is Excel 2010).



              If you enter 999,999,999,999,999 in a cell and add 1 to it in the cell below it correctly shows 1,000,000,000,000,000, but try to add another 1 and you get 1,000,000,000,000,000 again.



              1,000,000,000,000,000 to 1,000,000,000,000,005 show as 1,000,000,000,000,000
              1,000,000,000,000,006 to 1,000,000,000,000,015 show as 1,000,000,000,000,010
              1,000,000,000,000,016 to 1,000,000,000,000,025 show as 1,000,000,000,000,020



              Which is what you would expect with the midpoint rounding down.






              share|improve this answer































                -1














                If you are just entering information without having to do any math or calculations, format the cell as 'text'. Not sure why it won't work in the number format.






                share|improve this answer































                  -1














                  Or you could choose one number that is common with all the cells and replace it with a letter that isn't already present. Copy paste into Excel remove duplicates and sort before copying and pasting back in Word where you replace the letter back to the common number for example:



                  1300000000029577 13z0000000029577



                  1300000000029578 13z0000000029578



                  1300000000034748 13z0000000034748



                  1300000000086943 13z0000000086943






                  share|improve this answer
























                  • You can convert it to Number and increase the column

                    – yass
                    Apr 12 '17 at 15:39



















                  -1














                  In order to add more than 14 digits to an Excel cell, follow these steps:




                  1. Copy the data which has such numbers;

                  2. Paste it in a Notepad and click "Save As" and name the .txt file;

                  3. Open an excel sheet, Go to Data and click on "From Txt/Csv". (Refer to the picture in the link);

                  4. Select the .txt file that was saved;

                  5. A pop will appear and in that dialogue box click on "Load" button.


                  Snapshot in excel






                  share|improve this answer
























                    protected by Community Jan 19 at 16:33



                    Thank you for your interest in this question.
                    Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).



                    Would you like to answer one of these unanswered questions instead?














                    11 Answers
                    11






                    active

                    oldest

                    votes








                    11 Answers
                    11






                    active

                    oldest

                    votes









                    active

                    oldest

                    votes






                    active

                    oldest

                    votes









                    13














                    Some numbers are displayed in exponential format if the column is too narrow and you can fix this by increasing the width of the column.



                    However, very large numbers in Excel are stored in floating point format and cannot be represented in Excel exactly. You may be able to override their display using cell formatting but the true values will still be stored and processed using floating point arithmetic, with its inherent limitations.



                    If you need to perform calculations with greater precision you need an application that supports arbitrary precision arithmetic.






                    share|improve this answer
























                    • By increasing width of column also number format in exponential only

                      – user111921
                      Jan 3 '12 at 5:04











                    • @user111921, correct. If the number is very large it is stored in floating point format and must be displayed in exponential form, no matter how wide the column is.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:14











                    • NUmber format is normal number there is no floating point.For normal number range after 15 digits value the value is changes to exponential format

                      – user111921
                      Jan 3 '12 at 5:19






                    • 1





                      @user111921, correct. If you enter a large integer into Excel it will be converted to floating point (with some loss of precision) and displayed in exponential form. It is unavoidable in Excel and most other applications unless they specifically support arbitrary precision arithmetic.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:23











                    • To be precise, Excel 2010 doesn't support integers with more than 10 digits. Enter a number with 11 digits, or enter 9,999,999,999 and add one to it in a formula, and you end up with a floating point number. You can format it as an integer, but you still your low digits will be lost to rounding error.

                      – Isaac Rabinovitch
                      Oct 8 '12 at 4:48
















                    13














                    Some numbers are displayed in exponential format if the column is too narrow and you can fix this by increasing the width of the column.



                    However, very large numbers in Excel are stored in floating point format and cannot be represented in Excel exactly. You may be able to override their display using cell formatting but the true values will still be stored and processed using floating point arithmetic, with its inherent limitations.



                    If you need to perform calculations with greater precision you need an application that supports arbitrary precision arithmetic.






                    share|improve this answer
























                    • By increasing width of column also number format in exponential only

                      – user111921
                      Jan 3 '12 at 5:04











                    • @user111921, correct. If the number is very large it is stored in floating point format and must be displayed in exponential form, no matter how wide the column is.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:14











                    • NUmber format is normal number there is no floating point.For normal number range after 15 digits value the value is changes to exponential format

                      – user111921
                      Jan 3 '12 at 5:19






                    • 1





                      @user111921, correct. If you enter a large integer into Excel it will be converted to floating point (with some loss of precision) and displayed in exponential form. It is unavoidable in Excel and most other applications unless they specifically support arbitrary precision arithmetic.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:23











                    • To be precise, Excel 2010 doesn't support integers with more than 10 digits. Enter a number with 11 digits, or enter 9,999,999,999 and add one to it in a formula, and you end up with a floating point number. You can format it as an integer, but you still your low digits will be lost to rounding error.

                      – Isaac Rabinovitch
                      Oct 8 '12 at 4:48














                    13












                    13








                    13







                    Some numbers are displayed in exponential format if the column is too narrow and you can fix this by increasing the width of the column.



                    However, very large numbers in Excel are stored in floating point format and cannot be represented in Excel exactly. You may be able to override their display using cell formatting but the true values will still be stored and processed using floating point arithmetic, with its inherent limitations.



                    If you need to perform calculations with greater precision you need an application that supports arbitrary precision arithmetic.






                    share|improve this answer













                    Some numbers are displayed in exponential format if the column is too narrow and you can fix this by increasing the width of the column.



                    However, very large numbers in Excel are stored in floating point format and cannot be represented in Excel exactly. You may be able to override their display using cell formatting but the true values will still be stored and processed using floating point arithmetic, with its inherent limitations.



                    If you need to perform calculations with greater precision you need an application that supports arbitrary precision arithmetic.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Jan 3 '12 at 4:53









                    Mike FitzpatrickMike Fitzpatrick

                    14.5k33540




                    14.5k33540













                    • By increasing width of column also number format in exponential only

                      – user111921
                      Jan 3 '12 at 5:04











                    • @user111921, correct. If the number is very large it is stored in floating point format and must be displayed in exponential form, no matter how wide the column is.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:14











                    • NUmber format is normal number there is no floating point.For normal number range after 15 digits value the value is changes to exponential format

                      – user111921
                      Jan 3 '12 at 5:19






                    • 1





                      @user111921, correct. If you enter a large integer into Excel it will be converted to floating point (with some loss of precision) and displayed in exponential form. It is unavoidable in Excel and most other applications unless they specifically support arbitrary precision arithmetic.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:23











                    • To be precise, Excel 2010 doesn't support integers with more than 10 digits. Enter a number with 11 digits, or enter 9,999,999,999 and add one to it in a formula, and you end up with a floating point number. You can format it as an integer, but you still your low digits will be lost to rounding error.

                      – Isaac Rabinovitch
                      Oct 8 '12 at 4:48



















                    • By increasing width of column also number format in exponential only

                      – user111921
                      Jan 3 '12 at 5:04











                    • @user111921, correct. If the number is very large it is stored in floating point format and must be displayed in exponential form, no matter how wide the column is.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:14











                    • NUmber format is normal number there is no floating point.For normal number range after 15 digits value the value is changes to exponential format

                      – user111921
                      Jan 3 '12 at 5:19






                    • 1





                      @user111921, correct. If you enter a large integer into Excel it will be converted to floating point (with some loss of precision) and displayed in exponential form. It is unavoidable in Excel and most other applications unless they specifically support arbitrary precision arithmetic.

                      – Mike Fitzpatrick
                      Jan 3 '12 at 5:23











                    • To be precise, Excel 2010 doesn't support integers with more than 10 digits. Enter a number with 11 digits, or enter 9,999,999,999 and add one to it in a formula, and you end up with a floating point number. You can format it as an integer, but you still your low digits will be lost to rounding error.

                      – Isaac Rabinovitch
                      Oct 8 '12 at 4:48

















                    By increasing width of column also number format in exponential only

                    – user111921
                    Jan 3 '12 at 5:04





                    By increasing width of column also number format in exponential only

                    – user111921
                    Jan 3 '12 at 5:04













                    @user111921, correct. If the number is very large it is stored in floating point format and must be displayed in exponential form, no matter how wide the column is.

                    – Mike Fitzpatrick
                    Jan 3 '12 at 5:14





                    @user111921, correct. If the number is very large it is stored in floating point format and must be displayed in exponential form, no matter how wide the column is.

                    – Mike Fitzpatrick
                    Jan 3 '12 at 5:14













                    NUmber format is normal number there is no floating point.For normal number range after 15 digits value the value is changes to exponential format

                    – user111921
                    Jan 3 '12 at 5:19





                    NUmber format is normal number there is no floating point.For normal number range after 15 digits value the value is changes to exponential format

                    – user111921
                    Jan 3 '12 at 5:19




                    1




                    1





                    @user111921, correct. If you enter a large integer into Excel it will be converted to floating point (with some loss of precision) and displayed in exponential form. It is unavoidable in Excel and most other applications unless they specifically support arbitrary precision arithmetic.

                    – Mike Fitzpatrick
                    Jan 3 '12 at 5:23





                    @user111921, correct. If you enter a large integer into Excel it will be converted to floating point (with some loss of precision) and displayed in exponential form. It is unavoidable in Excel and most other applications unless they specifically support arbitrary precision arithmetic.

                    – Mike Fitzpatrick
                    Jan 3 '12 at 5:23













                    To be precise, Excel 2010 doesn't support integers with more than 10 digits. Enter a number with 11 digits, or enter 9,999,999,999 and add one to it in a formula, and you end up with a floating point number. You can format it as an integer, but you still your low digits will be lost to rounding error.

                    – Isaac Rabinovitch
                    Oct 8 '12 at 4:48





                    To be precise, Excel 2010 doesn't support integers with more than 10 digits. Enter a number with 11 digits, or enter 9,999,999,999 and add one to it in a formula, and you end up with a floating point number. You can format it as an integer, but you still your low digits will be lost to rounding error.

                    – Isaac Rabinovitch
                    Oct 8 '12 at 4:48













                    6














                    When you don't need to calculate with these numbers, you can treat them as text, see the other answers.
                    When you need to calculate with them, then it becomes difficult because Excel has only 15 siginificant digits. The possibilities I know are:




                    1. Split the number in 2 (or more) cells. Put a part of the number in
                      one cell and the remainder in another cell. The consequence is that
                      you need to develop your own formules for calculations.


                    2. Another solution is using add-in's. For a free one study the articles mentioned in http://www.excel-ticker.com/calculation-of-very-large-numbers-in-excel-part-5-add-in/







                    share|improve this answer




























                      6














                      When you don't need to calculate with these numbers, you can treat them as text, see the other answers.
                      When you need to calculate with them, then it becomes difficult because Excel has only 15 siginificant digits. The possibilities I know are:




                      1. Split the number in 2 (or more) cells. Put a part of the number in
                        one cell and the remainder in another cell. The consequence is that
                        you need to develop your own formules for calculations.


                      2. Another solution is using add-in's. For a free one study the articles mentioned in http://www.excel-ticker.com/calculation-of-very-large-numbers-in-excel-part-5-add-in/







                      share|improve this answer


























                        6












                        6








                        6







                        When you don't need to calculate with these numbers, you can treat them as text, see the other answers.
                        When you need to calculate with them, then it becomes difficult because Excel has only 15 siginificant digits. The possibilities I know are:




                        1. Split the number in 2 (or more) cells. Put a part of the number in
                          one cell and the remainder in another cell. The consequence is that
                          you need to develop your own formules for calculations.


                        2. Another solution is using add-in's. For a free one study the articles mentioned in http://www.excel-ticker.com/calculation-of-very-large-numbers-in-excel-part-5-add-in/







                        share|improve this answer













                        When you don't need to calculate with these numbers, you can treat them as text, see the other answers.
                        When you need to calculate with them, then it becomes difficult because Excel has only 15 siginificant digits. The possibilities I know are:




                        1. Split the number in 2 (or more) cells. Put a part of the number in
                          one cell and the remainder in another cell. The consequence is that
                          you need to develop your own formules for calculations.


                        2. Another solution is using add-in's. For a free one study the articles mentioned in http://www.excel-ticker.com/calculation-of-very-large-numbers-in-excel-part-5-add-in/








                        share|improve this answer












                        share|improve this answer



                        share|improve this answer










                        answered Feb 20 '13 at 16:13









                        Ben WelmanBen Welman

                        54942




                        54942























                            4














                            The reason is the limited precision that can be stored in a floating point variable. For a complete explanation you should read the paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic", by David Goldberg, published in the March, 1991 issue of Computing Surveys.



                            Another, more accessible site, is Chip Pearson's site.



                            In Excel, the floating point type is Double which is a IEEE 64-bit (8-byte) floating-point number. These can display 15 digit precision (well sort of, see the MSDN article Excel Worksheet and Expression Evaluation).






                            share|improve this answer






























                              4














                              The reason is the limited precision that can be stored in a floating point variable. For a complete explanation you should read the paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic", by David Goldberg, published in the March, 1991 issue of Computing Surveys.



                              Another, more accessible site, is Chip Pearson's site.



                              In Excel, the floating point type is Double which is a IEEE 64-bit (8-byte) floating-point number. These can display 15 digit precision (well sort of, see the MSDN article Excel Worksheet and Expression Evaluation).






                              share|improve this answer




























                                4












                                4








                                4







                                The reason is the limited precision that can be stored in a floating point variable. For a complete explanation you should read the paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic", by David Goldberg, published in the March, 1991 issue of Computing Surveys.



                                Another, more accessible site, is Chip Pearson's site.



                                In Excel, the floating point type is Double which is a IEEE 64-bit (8-byte) floating-point number. These can display 15 digit precision (well sort of, see the MSDN article Excel Worksheet and Expression Evaluation).






                                share|improve this answer















                                The reason is the limited precision that can be stored in a floating point variable. For a complete explanation you should read the paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic", by David Goldberg, published in the March, 1991 issue of Computing Surveys.



                                Another, more accessible site, is Chip Pearson's site.



                                In Excel, the floating point type is Double which is a IEEE 64-bit (8-byte) floating-point number. These can display 15 digit precision (well sort of, see the MSDN article Excel Worksheet and Expression Evaluation).







                                share|improve this answer














                                share|improve this answer



                                share|improve this answer








                                edited Jan 11 '13 at 10:46









                                Peter Mortensen

                                8,376166185




                                8,376166185










                                answered Jan 3 '12 at 6:11









                                chris neilsenchris neilsen

                                3,8651319




                                3,8651319























                                    0















                                    1. just copy your number from the cell

                                    2. format another cell(where to copy-destination cell) as text

                                    3. double click on the destination cell and paste in it.






                                    share|improve this answer






























                                      0















                                      1. just copy your number from the cell

                                      2. format another cell(where to copy-destination cell) as text

                                      3. double click on the destination cell and paste in it.






                                      share|improve this answer




























                                        0












                                        0








                                        0








                                        1. just copy your number from the cell

                                        2. format another cell(where to copy-destination cell) as text

                                        3. double click on the destination cell and paste in it.






                                        share|improve this answer
















                                        1. just copy your number from the cell

                                        2. format another cell(where to copy-destination cell) as text

                                        3. double click on the destination cell and paste in it.







                                        share|improve this answer














                                        share|improve this answer



                                        share|improve this answer








                                        edited Apr 12 '13 at 5:38









                                        Simon

                                        3,69721940




                                        3,69721940










                                        answered Apr 12 '13 at 5:10









                                        amit sharmaamit sharma

                                        1




                                        1























                                            0














                                            I had to have a large number in order to create a unique number for a website.



                                            In the end I created the large numbers by using concatenate to add cells together. Example:



                                            OL  2890000000  0000004 OL28900000000000004
                                            OL 2890000000 0000005 OL28900000000000005
                                            OL 2890000000 0000006 OL28900000000000006
                                            OL 2890000000 0000007 OL28900000000000007
                                            OL 2890000000 0000008 OL28900000000000008





                                            share|improve this answer






























                                              0














                                              I had to have a large number in order to create a unique number for a website.



                                              In the end I created the large numbers by using concatenate to add cells together. Example:



                                              OL  2890000000  0000004 OL28900000000000004
                                              OL 2890000000 0000005 OL28900000000000005
                                              OL 2890000000 0000006 OL28900000000000006
                                              OL 2890000000 0000007 OL28900000000000007
                                              OL 2890000000 0000008 OL28900000000000008





                                              share|improve this answer




























                                                0












                                                0








                                                0







                                                I had to have a large number in order to create a unique number for a website.



                                                In the end I created the large numbers by using concatenate to add cells together. Example:



                                                OL  2890000000  0000004 OL28900000000000004
                                                OL 2890000000 0000005 OL28900000000000005
                                                OL 2890000000 0000006 OL28900000000000006
                                                OL 2890000000 0000007 OL28900000000000007
                                                OL 2890000000 0000008 OL28900000000000008





                                                share|improve this answer















                                                I had to have a large number in order to create a unique number for a website.



                                                In the end I created the large numbers by using concatenate to add cells together. Example:



                                                OL  2890000000  0000004 OL28900000000000004
                                                OL 2890000000 0000005 OL28900000000000005
                                                OL 2890000000 0000006 OL28900000000000006
                                                OL 2890000000 0000007 OL28900000000000007
                                                OL 2890000000 0000008 OL28900000000000008






                                                share|improve this answer














                                                share|improve this answer



                                                share|improve this answer








                                                edited Jul 16 '13 at 10:18









                                                slhck

                                                162k47448470




                                                162k47448470










                                                answered Jul 16 '13 at 10:16









                                                Alan ValAlan Val

                                                1




                                                1























                                                    0














                                                    You might be able to solve the issue with these two steps:



                                                    1) Seperate the numbers into as many columns as necessary. Make sure the format is TEXT.



                                                    2) Use FORMULA>TEXT>CONCATENATE to combine the columns into one column and you should get your desired result.



                                                    In any case that you need to do so for running numbers like serial numbers for example, seperate the numbers and run them down in GENERAL format first, then combine.






                                                    share|improve this answer




























                                                      0














                                                      You might be able to solve the issue with these two steps:



                                                      1) Seperate the numbers into as many columns as necessary. Make sure the format is TEXT.



                                                      2) Use FORMULA>TEXT>CONCATENATE to combine the columns into one column and you should get your desired result.



                                                      In any case that you need to do so for running numbers like serial numbers for example, seperate the numbers and run them down in GENERAL format first, then combine.






                                                      share|improve this answer


























                                                        0












                                                        0








                                                        0







                                                        You might be able to solve the issue with these two steps:



                                                        1) Seperate the numbers into as many columns as necessary. Make sure the format is TEXT.



                                                        2) Use FORMULA>TEXT>CONCATENATE to combine the columns into one column and you should get your desired result.



                                                        In any case that you need to do so for running numbers like serial numbers for example, seperate the numbers and run them down in GENERAL format first, then combine.






                                                        share|improve this answer













                                                        You might be able to solve the issue with these two steps:



                                                        1) Seperate the numbers into as many columns as necessary. Make sure the format is TEXT.



                                                        2) Use FORMULA>TEXT>CONCATENATE to combine the columns into one column and you should get your desired result.



                                                        In any case that you need to do so for running numbers like serial numbers for example, seperate the numbers and run them down in GENERAL format first, then combine.







                                                        share|improve this answer












                                                        share|improve this answer



                                                        share|improve this answer










                                                        answered Jun 11 '15 at 2:26









                                                        Azaad MohamedAzaad Mohamed

                                                        1




                                                        1























                                                            0














                                                            I had the same issue with barcodes that I was pulling from a database, the solution that worked best for me is to pass the number to excel as a formula that displays text.



                                                            For example, instead of passing just the barcode, I was passing ="barcode" so that excel interprets as a string a shows the whole number without any other characters as in the ' solution. This way you can copy and paste the number easily.



                                                            Here's my SQL function:



                                                            ALTER function [dbo].[ConvertBarcode](@BARCODE varchar(40))
                                                            returns varchar(40)
                                                            as
                                                            begin
                                                            return '="'+@BARCODE+'"'
                                                            end


                                                            Happy coding!






                                                            share|improve this answer




























                                                              0














                                                              I had the same issue with barcodes that I was pulling from a database, the solution that worked best for me is to pass the number to excel as a formula that displays text.



                                                              For example, instead of passing just the barcode, I was passing ="barcode" so that excel interprets as a string a shows the whole number without any other characters as in the ' solution. This way you can copy and paste the number easily.



                                                              Here's my SQL function:



                                                              ALTER function [dbo].[ConvertBarcode](@BARCODE varchar(40))
                                                              returns varchar(40)
                                                              as
                                                              begin
                                                              return '="'+@BARCODE+'"'
                                                              end


                                                              Happy coding!






                                                              share|improve this answer


























                                                                0












                                                                0








                                                                0







                                                                I had the same issue with barcodes that I was pulling from a database, the solution that worked best for me is to pass the number to excel as a formula that displays text.



                                                                For example, instead of passing just the barcode, I was passing ="barcode" so that excel interprets as a string a shows the whole number without any other characters as in the ' solution. This way you can copy and paste the number easily.



                                                                Here's my SQL function:



                                                                ALTER function [dbo].[ConvertBarcode](@BARCODE varchar(40))
                                                                returns varchar(40)
                                                                as
                                                                begin
                                                                return '="'+@BARCODE+'"'
                                                                end


                                                                Happy coding!






                                                                share|improve this answer













                                                                I had the same issue with barcodes that I was pulling from a database, the solution that worked best for me is to pass the number to excel as a formula that displays text.



                                                                For example, instead of passing just the barcode, I was passing ="barcode" so that excel interprets as a string a shows the whole number without any other characters as in the ' solution. This way you can copy and paste the number easily.



                                                                Here's my SQL function:



                                                                ALTER function [dbo].[ConvertBarcode](@BARCODE varchar(40))
                                                                returns varchar(40)
                                                                as
                                                                begin
                                                                return '="'+@BARCODE+'"'
                                                                end


                                                                Happy coding!







                                                                share|improve this answer












                                                                share|improve this answer



                                                                share|improve this answer










                                                                answered Feb 22 '16 at 11:17









                                                                Mar YoMar Yo

                                                                1




                                                                1























                                                                    0














                                                                    You can correctly store the 15 most significant digits of an integer in Excel (my version is Excel 2010).



                                                                    If you enter 999,999,999,999,999 in a cell and add 1 to it in the cell below it correctly shows 1,000,000,000,000,000, but try to add another 1 and you get 1,000,000,000,000,000 again.



                                                                    1,000,000,000,000,000 to 1,000,000,000,000,005 show as 1,000,000,000,000,000
                                                                    1,000,000,000,000,006 to 1,000,000,000,000,015 show as 1,000,000,000,000,010
                                                                    1,000,000,000,000,016 to 1,000,000,000,000,025 show as 1,000,000,000,000,020



                                                                    Which is what you would expect with the midpoint rounding down.






                                                                    share|improve this answer




























                                                                      0














                                                                      You can correctly store the 15 most significant digits of an integer in Excel (my version is Excel 2010).



                                                                      If you enter 999,999,999,999,999 in a cell and add 1 to it in the cell below it correctly shows 1,000,000,000,000,000, but try to add another 1 and you get 1,000,000,000,000,000 again.



                                                                      1,000,000,000,000,000 to 1,000,000,000,000,005 show as 1,000,000,000,000,000
                                                                      1,000,000,000,000,006 to 1,000,000,000,000,015 show as 1,000,000,000,000,010
                                                                      1,000,000,000,000,016 to 1,000,000,000,000,025 show as 1,000,000,000,000,020



                                                                      Which is what you would expect with the midpoint rounding down.






                                                                      share|improve this answer


























                                                                        0












                                                                        0








                                                                        0







                                                                        You can correctly store the 15 most significant digits of an integer in Excel (my version is Excel 2010).



                                                                        If you enter 999,999,999,999,999 in a cell and add 1 to it in the cell below it correctly shows 1,000,000,000,000,000, but try to add another 1 and you get 1,000,000,000,000,000 again.



                                                                        1,000,000,000,000,000 to 1,000,000,000,000,005 show as 1,000,000,000,000,000
                                                                        1,000,000,000,000,006 to 1,000,000,000,000,015 show as 1,000,000,000,000,010
                                                                        1,000,000,000,000,016 to 1,000,000,000,000,025 show as 1,000,000,000,000,020



                                                                        Which is what you would expect with the midpoint rounding down.






                                                                        share|improve this answer













                                                                        You can correctly store the 15 most significant digits of an integer in Excel (my version is Excel 2010).



                                                                        If you enter 999,999,999,999,999 in a cell and add 1 to it in the cell below it correctly shows 1,000,000,000,000,000, but try to add another 1 and you get 1,000,000,000,000,000 again.



                                                                        1,000,000,000,000,000 to 1,000,000,000,000,005 show as 1,000,000,000,000,000
                                                                        1,000,000,000,000,006 to 1,000,000,000,000,015 show as 1,000,000,000,000,010
                                                                        1,000,000,000,000,016 to 1,000,000,000,000,025 show as 1,000,000,000,000,020



                                                                        Which is what you would expect with the midpoint rounding down.







                                                                        share|improve this answer












                                                                        share|improve this answer



                                                                        share|improve this answer










                                                                        answered Dec 14 '17 at 14:21









                                                                        Stephen TurnerStephen Turner

                                                                        1639




                                                                        1639























                                                                            -1














                                                                            If you are just entering information without having to do any math or calculations, format the cell as 'text'. Not sure why it won't work in the number format.






                                                                            share|improve this answer




























                                                                              -1














                                                                              If you are just entering information without having to do any math or calculations, format the cell as 'text'. Not sure why it won't work in the number format.






                                                                              share|improve this answer


























                                                                                -1












                                                                                -1








                                                                                -1







                                                                                If you are just entering information without having to do any math or calculations, format the cell as 'text'. Not sure why it won't work in the number format.






                                                                                share|improve this answer













                                                                                If you are just entering information without having to do any math or calculations, format the cell as 'text'. Not sure why it won't work in the number format.







                                                                                share|improve this answer












                                                                                share|improve this answer



                                                                                share|improve this answer










                                                                                answered Jul 23 '14 at 17:50









                                                                                MaryMary

                                                                                1




                                                                                1























                                                                                    -1














                                                                                    Or you could choose one number that is common with all the cells and replace it with a letter that isn't already present. Copy paste into Excel remove duplicates and sort before copying and pasting back in Word where you replace the letter back to the common number for example:



                                                                                    1300000000029577 13z0000000029577



                                                                                    1300000000029578 13z0000000029578



                                                                                    1300000000034748 13z0000000034748



                                                                                    1300000000086943 13z0000000086943






                                                                                    share|improve this answer
























                                                                                    • You can convert it to Number and increase the column

                                                                                      – yass
                                                                                      Apr 12 '17 at 15:39
















                                                                                    -1














                                                                                    Or you could choose one number that is common with all the cells and replace it with a letter that isn't already present. Copy paste into Excel remove duplicates and sort before copying and pasting back in Word where you replace the letter back to the common number for example:



                                                                                    1300000000029577 13z0000000029577



                                                                                    1300000000029578 13z0000000029578



                                                                                    1300000000034748 13z0000000034748



                                                                                    1300000000086943 13z0000000086943






                                                                                    share|improve this answer
























                                                                                    • You can convert it to Number and increase the column

                                                                                      – yass
                                                                                      Apr 12 '17 at 15:39














                                                                                    -1












                                                                                    -1








                                                                                    -1







                                                                                    Or you could choose one number that is common with all the cells and replace it with a letter that isn't already present. Copy paste into Excel remove duplicates and sort before copying and pasting back in Word where you replace the letter back to the common number for example:



                                                                                    1300000000029577 13z0000000029577



                                                                                    1300000000029578 13z0000000029578



                                                                                    1300000000034748 13z0000000034748



                                                                                    1300000000086943 13z0000000086943






                                                                                    share|improve this answer













                                                                                    Or you could choose one number that is common with all the cells and replace it with a letter that isn't already present. Copy paste into Excel remove duplicates and sort before copying and pasting back in Word where you replace the letter back to the common number for example:



                                                                                    1300000000029577 13z0000000029577



                                                                                    1300000000029578 13z0000000029578



                                                                                    1300000000034748 13z0000000034748



                                                                                    1300000000086943 13z0000000086943







                                                                                    share|improve this answer












                                                                                    share|improve this answer



                                                                                    share|improve this answer










                                                                                    answered Apr 12 '17 at 15:16









                                                                                    JustSayingJustSaying

                                                                                    1




                                                                                    1













                                                                                    • You can convert it to Number and increase the column

                                                                                      – yass
                                                                                      Apr 12 '17 at 15:39



















                                                                                    • You can convert it to Number and increase the column

                                                                                      – yass
                                                                                      Apr 12 '17 at 15:39

















                                                                                    You can convert it to Number and increase the column

                                                                                    – yass
                                                                                    Apr 12 '17 at 15:39





                                                                                    You can convert it to Number and increase the column

                                                                                    – yass
                                                                                    Apr 12 '17 at 15:39











                                                                                    -1














                                                                                    In order to add more than 14 digits to an Excel cell, follow these steps:




                                                                                    1. Copy the data which has such numbers;

                                                                                    2. Paste it in a Notepad and click "Save As" and name the .txt file;

                                                                                    3. Open an excel sheet, Go to Data and click on "From Txt/Csv". (Refer to the picture in the link);

                                                                                    4. Select the .txt file that was saved;

                                                                                    5. A pop will appear and in that dialogue box click on "Load" button.


                                                                                    Snapshot in excel






                                                                                    share|improve this answer






























                                                                                      -1














                                                                                      In order to add more than 14 digits to an Excel cell, follow these steps:




                                                                                      1. Copy the data which has such numbers;

                                                                                      2. Paste it in a Notepad and click "Save As" and name the .txt file;

                                                                                      3. Open an excel sheet, Go to Data and click on "From Txt/Csv". (Refer to the picture in the link);

                                                                                      4. Select the .txt file that was saved;

                                                                                      5. A pop will appear and in that dialogue box click on "Load" button.


                                                                                      Snapshot in excel






                                                                                      share|improve this answer




























                                                                                        -1












                                                                                        -1








                                                                                        -1







                                                                                        In order to add more than 14 digits to an Excel cell, follow these steps:




                                                                                        1. Copy the data which has such numbers;

                                                                                        2. Paste it in a Notepad and click "Save As" and name the .txt file;

                                                                                        3. Open an excel sheet, Go to Data and click on "From Txt/Csv". (Refer to the picture in the link);

                                                                                        4. Select the .txt file that was saved;

                                                                                        5. A pop will appear and in that dialogue box click on "Load" button.


                                                                                        Snapshot in excel






                                                                                        share|improve this answer















                                                                                        In order to add more than 14 digits to an Excel cell, follow these steps:




                                                                                        1. Copy the data which has such numbers;

                                                                                        2. Paste it in a Notepad and click "Save As" and name the .txt file;

                                                                                        3. Open an excel sheet, Go to Data and click on "From Txt/Csv". (Refer to the picture in the link);

                                                                                        4. Select the .txt file that was saved;

                                                                                        5. A pop will appear and in that dialogue box click on "Load" button.


                                                                                        Snapshot in excel







                                                                                        share|improve this answer














                                                                                        share|improve this answer



                                                                                        share|improve this answer








                                                                                        edited Oct 25 '18 at 15:31









                                                                                        Mr Shunz

                                                                                        1,82512017




                                                                                        1,82512017










                                                                                        answered Oct 25 '18 at 10:54









                                                                                        Hariharan PadmanabhanHariharan Padmanabhan

                                                                                        1




                                                                                        1

















                                                                                            protected by Community Jan 19 at 16:33



                                                                                            Thank you for your interest in this question.
                                                                                            Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).



                                                                                            Would you like to answer one of these unanswered questions instead?



                                                                                            Popular posts from this blog

                                                                                            Сан-Квентин

                                                                                            Алькесар

                                                                                            Josef Freinademetz