Keeping a fixed constant (like letter “M”) and a variable (like a number “100”) in the same cell in...











up vote
1
down vote

favorite












In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
(this is difficult to put in words)



example:

So, I have different values, like 100M, 50M, 30M, 40M, etc.



Now, can I keep the "M" fixed so that I only need to input the numerical value?
Like I just type "100" but it shows "100M"?



Is it also possible to have a formula that ignores the "M"?



Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?



Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?






microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007







share|improve this question


























    up vote
    1
    down vote

    favorite












    In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
    (this is difficult to put in words)



    example:

    So, I have different values, like 100M, 50M, 30M, 40M, etc.



    Now, can I keep the "M" fixed so that I only need to input the numerical value?
    Like I just type "100" but it shows "100M"?



    Is it also possible to have a formula that ignores the "M"?



    Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?



    Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?






    microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007







    share|improve this question
























      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
      (this is difficult to put in words)



      example:

      So, I have different values, like 100M, 50M, 30M, 40M, etc.



      Now, can I keep the "M" fixed so that I only need to input the numerical value?
      Like I just type "100" but it shows "100M"?



      Is it also possible to have a formula that ignores the "M"?



      Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?



      Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?






      microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007







      share|improve this question













      In excel, is there a method where a constant term can be fixed in the cell and I only need to input the variable term.
      (this is difficult to put in words)



      example:

      So, I have different values, like 100M, 50M, 30M, 40M, etc.



      Now, can I keep the "M" fixed so that I only need to input the numerical value?
      Like I just type "100" but it shows "100M"?



      Is it also possible to have a formula that ignores the "M"?



      Like, A1=100M, B1=30M. Now, I want C1=A1-B1 to be "70M" instead of "#value!"?



      Is this possible to do if I can keep the "M" as a fixed value instead of manually inputting it?






      microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007




      microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 17 hours ago









      user28219

      353125




      353125






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          2
          down vote













          select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]



          done.



          If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]



          hope it helps. ( :



          p/s: Idea source = setting the 'M' as a currency character.






          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: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














             

            draft saved


            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1374945%2fkeeping-a-fixed-constant-like-letter-m-and-a-variable-like-a-number-100%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
            2
            down vote













            select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]



            done.



            If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]



            hope it helps. ( :



            p/s: Idea source = setting the 'M' as a currency character.






            share|improve this answer

























              up vote
              2
              down vote













              select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]



              done.



              If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]



              hope it helps. ( :



              p/s: Idea source = setting the 'M' as a currency character.






              share|improve this answer























                up vote
                2
                down vote










                up vote
                2
                down vote









                select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]



                done.



                If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]



                hope it helps. ( :



                p/s: Idea source = setting the 'M' as a currency character.






                share|improve this answer












                select all the cell you need.. r-click > format cell > custom : #,##0.00 [$M]



                done.



                If you don't need the comma separator or decimal.. just put 0 [$M] will do. If without the space between the number and 'M' .. then use 0[$M]



                hope it helps. ( :



                p/s: Idea source = setting the 'M' as a currency character.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 17 hours ago









                p._phidot_

                47328




                47328






























                     

                    draft saved


                    draft discarded



















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1374945%2fkeeping-a-fixed-constant-like-letter-m-and-a-variable-like-a-number-100%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest






































































                    -

                    Popular posts from this blog

                    Probability when a professor distributes a quiz and homework assignment to a class of n students.

                    Image
                    0 0 $begingroup$ Need help with this problem. Suppose our lazy professor collects a quiz and a homework assignment from a class of n students one day, then distributes both the quizzes and the homework assignments back to the class in a random fashion for grading. Each student receives one quiz and one homework assignment to grade. (a) What is the probability that every student receives someone else's quiz to grade, and someone else's homework to grade? (b) What is the probability that no student receives both their own quiz and their own homework assignment to grade? In this case, some students may receive their own quiz, and others may receive their own homework assignment. (c) Compute the limiting probability as n approaches infinity in each case. ...
                    Read more

                    Aardman Animations

                    Image
                    Aardman Animations, Ltd. Aardman Animations Tipo privada Atividade Animação em stop-motion , Animação em CGI Fundação 1972 Fundador(es) Peter Lord David Sproxton Sede Bristol, Inglaterra  Reino Unido Proprietário(s) Dreamworks Pessoas-chave Peter Lord David Sproxton Nick Park Divisões Aardman Features Aardman Digital Aardman Commercials Aardman Broadcast Aardman International Aardman Rights Aardman Effects Aardman 3-D Systems Aardman Nathan Love AardBoiled Website oficial aardman.com ...
                    Read more

                    Are they similar matrix

                    Image
                    0 $begingroup$ Do $begin{bmatrix} 0&i&0\0&0&1\0&0&0 end{bmatrix} $ and $begin{bmatrix} 0&0&0\-i&0&0\0&1&0 end{bmatrix} $ are similar.Is this True/false Clearly both are nilpotent and one is conjucate transpose of other but how to know if they are similar.i'm stuck. Please help me linear-algebra vector-spaces eigenvalues-eigenvectors generalizedeigenvector share | cite | improve this question edited Dec 10 '18 at 6:38 Vasanth Kris asked Dec 10 '18 at 6:19 ...
                    Read more