In Excel, when I enter 22222.09482 then I see 22222.0948199999 number in the formula bar

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
3
down vote

favorite
2












Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the problem.



Sample error



I see the same behavior when I enter the following numbers:



22222.09482
33333.09482
44444.09482
55555.09482


but when I enter 11111.09482 and 66666.09482, 77777.09482.. until 99999.09482 then they shows correctly. I am not sure is this related to rounding ? I didn't setup any rounding profiles. Could you please help me in resolving the issue.










share|improve this question









New contributor




user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



















  • Neat find, does same for me - can you just use ROUND()? =ROUND(A1,5), then copy/paste the data as Values and remove the original numbers?
    – BruceWayne
    2 hours ago







  • 1




    @BruceWayne, interestingly the ROUND() shows the correct digits but the copy/paste as value takes it back to the original issue!
    – Rey Juna
    18 mins ago







  • 1




    @ReyJuna - Then just do ROUND(A1,5) again on the pasted values. Then copy/paste those as values, and Round() again, then copy/paste. ... :P ...that's interesting, and it looks like @EugenRieck has the reasoning. Nice question!
    – BruceWayne
    16 mins ago














up vote
3
down vote

favorite
2












Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the problem.



Sample error



I see the same behavior when I enter the following numbers:



22222.09482
33333.09482
44444.09482
55555.09482


but when I enter 11111.09482 and 66666.09482, 77777.09482.. until 99999.09482 then they shows correctly. I am not sure is this related to rounding ? I didn't setup any rounding profiles. Could you please help me in resolving the issue.










share|improve this question









New contributor




user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



















  • Neat find, does same for me - can you just use ROUND()? =ROUND(A1,5), then copy/paste the data as Values and remove the original numbers?
    – BruceWayne
    2 hours ago







  • 1




    @BruceWayne, interestingly the ROUND() shows the correct digits but the copy/paste as value takes it back to the original issue!
    – Rey Juna
    18 mins ago







  • 1




    @ReyJuna - Then just do ROUND(A1,5) again on the pasted values. Then copy/paste those as values, and Round() again, then copy/paste. ... :P ...that's interesting, and it looks like @EugenRieck has the reasoning. Nice question!
    – BruceWayne
    16 mins ago












up vote
3
down vote

favorite
2









up vote
3
down vote

favorite
2






2





Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the problem.



Sample error



I see the same behavior when I enter the following numbers:



22222.09482
33333.09482
44444.09482
55555.09482


but when I enter 11111.09482 and 66666.09482, 77777.09482.. until 99999.09482 then they shows correctly. I am not sure is this related to rounding ? I didn't setup any rounding profiles. Could you please help me in resolving the issue.










share|improve this question









New contributor




user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











Could you please help - as I have a weird situation that when I enter a number 22222.09482 in cell then I see a different number 22222.0948199999 in the formula bar. Below is the snapshot of the problem.



Sample error



I see the same behavior when I enter the following numbers:



22222.09482
33333.09482
44444.09482
55555.09482


but when I enter 11111.09482 and 66666.09482, 77777.09482.. until 99999.09482 then they shows correctly. I am not sure is this related to rounding ? I didn't setup any rounding profiles. Could you please help me in resolving the issue.







microsoft-excel microsoft-excel-2016






share|improve this question









New contributor




user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 2 hours ago









Glorfindel

1,18941220




1,18941220






New contributor




user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 3 hours ago









user954171

161




161




New contributor




user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






user954171 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











  • Neat find, does same for me - can you just use ROUND()? =ROUND(A1,5), then copy/paste the data as Values and remove the original numbers?
    – BruceWayne
    2 hours ago







  • 1




    @BruceWayne, interestingly the ROUND() shows the correct digits but the copy/paste as value takes it back to the original issue!
    – Rey Juna
    18 mins ago







  • 1




    @ReyJuna - Then just do ROUND(A1,5) again on the pasted values. Then copy/paste those as values, and Round() again, then copy/paste. ... :P ...that's interesting, and it looks like @EugenRieck has the reasoning. Nice question!
    – BruceWayne
    16 mins ago
















  • Neat find, does same for me - can you just use ROUND()? =ROUND(A1,5), then copy/paste the data as Values and remove the original numbers?
    – BruceWayne
    2 hours ago







  • 1




    @BruceWayne, interestingly the ROUND() shows the correct digits but the copy/paste as value takes it back to the original issue!
    – Rey Juna
    18 mins ago







  • 1




    @ReyJuna - Then just do ROUND(A1,5) again on the pasted values. Then copy/paste those as values, and Round() again, then copy/paste. ... :P ...that's interesting, and it looks like @EugenRieck has the reasoning. Nice question!
    – BruceWayne
    16 mins ago















Neat find, does same for me - can you just use ROUND()? =ROUND(A1,5), then copy/paste the data as Values and remove the original numbers?
– BruceWayne
2 hours ago





Neat find, does same for me - can you just use ROUND()? =ROUND(A1,5), then copy/paste the data as Values and remove the original numbers?
– BruceWayne
2 hours ago





1




1




@BruceWayne, interestingly the ROUND() shows the correct digits but the copy/paste as value takes it back to the original issue!
– Rey Juna
18 mins ago





@BruceWayne, interestingly the ROUND() shows the correct digits but the copy/paste as value takes it back to the original issue!
– Rey Juna
18 mins ago





1




1




@ReyJuna - Then just do ROUND(A1,5) again on the pasted values. Then copy/paste those as values, and Round() again, then copy/paste. ... :P ...that's interesting, and it looks like @EugenRieck has the reasoning. Nice question!
– BruceWayne
16 mins ago




@ReyJuna - Then just do ROUND(A1,5) again on the pasted values. Then copy/paste those as values, and Round() again, then copy/paste. ... :P ...that's interesting, and it looks like @EugenRieck has the reasoning. Nice question!
– BruceWayne
16 mins ago










1 Answer
1






active

oldest

votes

















up vote
6
down vote













When doing it's calculations, Excel needs to find a good internal binary representation for the numbers it uses. In your case, it uses a floating point number, and as a matter of fact this data format has a (very good) approximation for your number, but no exact match. So if you don't explicitly tell Excel which output format to use, it will do a "best effort", resulting in an output that is closer to the internally calculated value, but is not exactly the text you enter.



Just to make this clear: Understanding, that the text you entered represents a number and converting the sequence of digits into a number already fulfills the definition of "calculation" from above.






share|improve this answer






















    Your Answer







    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "3"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: false,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );






    user954171 is a new contributor. Be nice, and check out our Code of Conduct.









     

    draft saved


    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1367025%2fin-excel-when-i-enter-22222-09482-then-i-see-22222-0948199999-number-in-the-for%23new-answer', 'question_page');

    );

    Post as a guest






























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    6
    down vote













    When doing it's calculations, Excel needs to find a good internal binary representation for the numbers it uses. In your case, it uses a floating point number, and as a matter of fact this data format has a (very good) approximation for your number, but no exact match. So if you don't explicitly tell Excel which output format to use, it will do a "best effort", resulting in an output that is closer to the internally calculated value, but is not exactly the text you enter.



    Just to make this clear: Understanding, that the text you entered represents a number and converting the sequence of digits into a number already fulfills the definition of "calculation" from above.






    share|improve this answer


























      up vote
      6
      down vote













      When doing it's calculations, Excel needs to find a good internal binary representation for the numbers it uses. In your case, it uses a floating point number, and as a matter of fact this data format has a (very good) approximation for your number, but no exact match. So if you don't explicitly tell Excel which output format to use, it will do a "best effort", resulting in an output that is closer to the internally calculated value, but is not exactly the text you enter.



      Just to make this clear: Understanding, that the text you entered represents a number and converting the sequence of digits into a number already fulfills the definition of "calculation" from above.






      share|improve this answer
























        up vote
        6
        down vote










        up vote
        6
        down vote









        When doing it's calculations, Excel needs to find a good internal binary representation for the numbers it uses. In your case, it uses a floating point number, and as a matter of fact this data format has a (very good) approximation for your number, but no exact match. So if you don't explicitly tell Excel which output format to use, it will do a "best effort", resulting in an output that is closer to the internally calculated value, but is not exactly the text you enter.



        Just to make this clear: Understanding, that the text you entered represents a number and converting the sequence of digits into a number already fulfills the definition of "calculation" from above.






        share|improve this answer














        When doing it's calculations, Excel needs to find a good internal binary representation for the numbers it uses. In your case, it uses a floating point number, and as a matter of fact this data format has a (very good) approximation for your number, but no exact match. So if you don't explicitly tell Excel which output format to use, it will do a "best effort", resulting in an output that is closer to the internally calculated value, but is not exactly the text you enter.



        Just to make this clear: Understanding, that the text you entered represents a number and converting the sequence of digits into a number already fulfills the definition of "calculation" from above.







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited 2 hours ago









        JakeGould

        30k1092133




        30k1092133










        answered 2 hours ago









        Eugen Rieck

        8,52421923




        8,52421923




















            user954171 is a new contributor. Be nice, and check out our Code of Conduct.









             

            draft saved


            draft discarded


















            user954171 is a new contributor. Be nice, and check out our Code of Conduct.












            user954171 is a new contributor. Be nice, and check out our Code of Conduct.











            user954171 is a new contributor. Be nice, and check out our Code of Conduct.













             


            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1367025%2fin-excel-when-i-enter-22222-09482-then-i-see-22222-0948199999-number-in-the-for%23new-answer', 'question_page');

            );

            Post as a guest













































































            Popular posts from this blog

            How to check contact read email or not when send email to Individual?

            Displaying single band from multi-band raster using QGIS

            How many registers does an x86_64 CPU actually have?