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 21 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 21 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

                    Список кардиналов, возведённых папой римским Каликстом III

                    Image
                    Папа Каликст III Кардиналы, возведённые Папой римским Каликстом III  — 9 прелатов и мирян были возведены в сан кардинала на двух Консисториях за трёхлетний понтификат Каликста III. Самой крупной консисторией были Консистория от 17 декабря 1456 года, на которой было возведено шесть кардиналов. Папа Каллист III хотел назвать отца Жан Сорета, O.Carm., епископом или кардиналом, но он отказался, потому что хотел посвятить себя своему ордену и продвижению религиозного рвения и соблюдения устава монашеского ордена. Консистория от 17 сентября 1456 года | Луис Хуан дель Мила, племянник Его Святейшества, епископ Сегорбе (королевство Арагон); Жайме Португальский, администратор архиепархии Лиссабона (королевство Португалия); Родриго де Борха-и-Борха, племянник Его Святейшества, ризничий Валенсии (Папская область). Консистория от 17 декабря 1456 года | Ринальдо Пишичелло, архиепископ Неаполя (Неаполитанское королевство); Хуан де Мелья, епископ Саморы (королевство Ка
                    Read more

                    Deduzione

                    Image
                    .mw-parser-output .nota-disambigua{clear:both;margin-bottom:.5em;border:1px solid #CCC;padding-left:4px}.mw-parser-output .nota-disambigua i{vertical-align:middle} Disambiguazione – Se stai cercando il teorema, vedi Teorema di deduzione . Disambiguazione – Se stai cercando il concetto di deduzione in economia, vedi deduzione fiscale . Il ragionamento deduttivo umano assimilato a un meccanismo Il metodo deduttivo o deduzione è il procedimento razionale che fa derivare una certa conclusione da premesse più generiche, dentro cui quella conclusione è implicita. Il termine significa letteralmente «condurre da», perché proviene dal latino "de" (traducibile con da , preposizione indicante provenienza, o moto di discesa dall'alto verso il basso) e "ducere" ( condurre ). Questo metodo parte da postulati e princìpi primi e, attraverso una serie di rigorose concatenazioni logiche, procede verso determinazioni più particolari attinenti alla realtà tangi
                    Read more

                    Mysql.sock missing - “Can't connect to local MySQL server through socket”

                    Image
                    .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 Operating System - OSX 10.11.2 MAMP version - 3.5 I'm following along with this guide, setting up wordpress with Xammp on PC and MAMP on Mac, where I'm in step "Mac - 4" is asked to input: "In the Terminal run: /Applications/MAMP/Library/bin/mysqladmin -u root -p password {Your Windows MySQL password here}" However, this (with out bracket text) results in error message: error: 'Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/Applications/MAMP/tmp/mysql/mysql.sock'
                    Read more