where can i find the grammar guide for excel format syntax?











up vote
3
down vote

favorite
1












I'm trying to control the display of excel cells using the customized format.



For example



#,##0;(#,##0)


will shows positive numbers as usual, but negative numbers with brackets instead of with a - sign.



where can i find the introduction of the syntax? for example i don't know how to make negative numbers to show as red, also i'm not sure how to specify the precision.










share|improve this question


























    up vote
    3
    down vote

    favorite
    1












    I'm trying to control the display of excel cells using the customized format.



    For example



    #,##0;(#,##0)


    will shows positive numbers as usual, but negative numbers with brackets instead of with a - sign.



    where can i find the introduction of the syntax? for example i don't know how to make negative numbers to show as red, also i'm not sure how to specify the precision.










    share|improve this question
























      up vote
      3
      down vote

      favorite
      1









      up vote
      3
      down vote

      favorite
      1






      1





      I'm trying to control the display of excel cells using the customized format.



      For example



      #,##0;(#,##0)


      will shows positive numbers as usual, but negative numbers with brackets instead of with a - sign.



      where can i find the introduction of the syntax? for example i don't know how to make negative numbers to show as red, also i'm not sure how to specify the precision.










      share|improve this question













      I'm trying to control the display of excel cells using the customized format.



      For example



      #,##0;(#,##0)


      will shows positive numbers as usual, but negative numbers with brackets instead of with a - sign.



      where can i find the introduction of the syntax? for example i don't know how to make negative numbers to show as red, also i'm not sure how to specify the precision.







      microsoft-excel






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 3 hours ago









      athos

      74771636




      74771636






















          2 Answers
          2






          active

          oldest

          votes

















          up vote
          5
          down vote



          accepted










          Try this Microsoft article "Review guidelines for customizing a number format"



              A number format can have up to four sections of code, separated by semicolons. 
          These code sections define the format for positive numbers, negative numbers,
          zero values, and text, in that order.

          <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

          For example, you can use these code sections to create the following custom format:

          [Blue]#,##0.00_);[Red](#,##0.00);0.00;"sales "@





          share|improve this answer




























            up vote
            0
            down vote













            You can use these Custom formats to put Negative Numbers in Red color, inside Brackets with Minus Sign, and Positive Numbers without Brackets and any Sign in Black Color, (which can be Blue or Even Green also).



            [Black]#,##0.00_);[Red](-#,##0.00);0.00



            #,##0.00_);[Red](-#,##0.00)



            For example:



            enter image description here



            99,000.00



            enter image description here



            This Custom Format will show Negative Number with Minus Sing in Black Color without Brackets.



            #,##0.00_) -99,000.00



            For more details you can check these Web Sites:



            https://exceljet.net/custom-number-formats



            https://www.ablebits.com/office-addins-blog/2016/07/07/custom-excel-number-format/



            Note, Color codes [Black] & [Red] are editable like, [Blue] or [Green].






            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%2f1385410%2fwhere-can-i-find-the-grammar-guide-for-excel-format-syntax%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes








              up vote
              5
              down vote



              accepted










              Try this Microsoft article "Review guidelines for customizing a number format"



                  A number format can have up to four sections of code, separated by semicolons. 
              These code sections define the format for positive numbers, negative numbers,
              zero values, and text, in that order.

              <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

              For example, you can use these code sections to create the following custom format:

              [Blue]#,##0.00_);[Red](#,##0.00);0.00;"sales "@





              share|improve this answer

























                up vote
                5
                down vote



                accepted










                Try this Microsoft article "Review guidelines for customizing a number format"



                    A number format can have up to four sections of code, separated by semicolons. 
                These code sections define the format for positive numbers, negative numbers,
                zero values, and text, in that order.

                <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

                For example, you can use these code sections to create the following custom format:

                [Blue]#,##0.00_);[Red](#,##0.00);0.00;"sales "@





                share|improve this answer























                  up vote
                  5
                  down vote



                  accepted







                  up vote
                  5
                  down vote



                  accepted






                  Try this Microsoft article "Review guidelines for customizing a number format"



                      A number format can have up to four sections of code, separated by semicolons. 
                  These code sections define the format for positive numbers, negative numbers,
                  zero values, and text, in that order.

                  <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

                  For example, you can use these code sections to create the following custom format:

                  [Blue]#,##0.00_);[Red](#,##0.00);0.00;"sales "@





                  share|improve this answer












                  Try this Microsoft article "Review guidelines for customizing a number format"



                      A number format can have up to four sections of code, separated by semicolons. 
                  These code sections define the format for positive numbers, negative numbers,
                  zero values, and text, in that order.

                  <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

                  For example, you can use these code sections to create the following custom format:

                  [Blue]#,##0.00_);[Red](#,##0.00);0.00;"sales "@






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 3 hours ago









                  teylyn

                  16.7k22438




                  16.7k22438
























                      up vote
                      0
                      down vote













                      You can use these Custom formats to put Negative Numbers in Red color, inside Brackets with Minus Sign, and Positive Numbers without Brackets and any Sign in Black Color, (which can be Blue or Even Green also).



                      [Black]#,##0.00_);[Red](-#,##0.00);0.00



                      #,##0.00_);[Red](-#,##0.00)



                      For example:



                      enter image description here



                      99,000.00



                      enter image description here



                      This Custom Format will show Negative Number with Minus Sing in Black Color without Brackets.



                      #,##0.00_) -99,000.00



                      For more details you can check these Web Sites:



                      https://exceljet.net/custom-number-formats



                      https://www.ablebits.com/office-addins-blog/2016/07/07/custom-excel-number-format/



                      Note, Color codes [Black] & [Red] are editable like, [Blue] or [Green].






                      share|improve this answer



























                        up vote
                        0
                        down vote













                        You can use these Custom formats to put Negative Numbers in Red color, inside Brackets with Minus Sign, and Positive Numbers without Brackets and any Sign in Black Color, (which can be Blue or Even Green also).



                        [Black]#,##0.00_);[Red](-#,##0.00);0.00



                        #,##0.00_);[Red](-#,##0.00)



                        For example:



                        enter image description here



                        99,000.00



                        enter image description here



                        This Custom Format will show Negative Number with Minus Sing in Black Color without Brackets.



                        #,##0.00_) -99,000.00



                        For more details you can check these Web Sites:



                        https://exceljet.net/custom-number-formats



                        https://www.ablebits.com/office-addins-blog/2016/07/07/custom-excel-number-format/



                        Note, Color codes [Black] & [Red] are editable like, [Blue] or [Green].






                        share|improve this answer

























                          up vote
                          0
                          down vote










                          up vote
                          0
                          down vote









                          You can use these Custom formats to put Negative Numbers in Red color, inside Brackets with Minus Sign, and Positive Numbers without Brackets and any Sign in Black Color, (which can be Blue or Even Green also).



                          [Black]#,##0.00_);[Red](-#,##0.00);0.00



                          #,##0.00_);[Red](-#,##0.00)



                          For example:



                          enter image description here



                          99,000.00



                          enter image description here



                          This Custom Format will show Negative Number with Minus Sing in Black Color without Brackets.



                          #,##0.00_) -99,000.00



                          For more details you can check these Web Sites:



                          https://exceljet.net/custom-number-formats



                          https://www.ablebits.com/office-addins-blog/2016/07/07/custom-excel-number-format/



                          Note, Color codes [Black] & [Red] are editable like, [Blue] or [Green].






                          share|improve this answer














                          You can use these Custom formats to put Negative Numbers in Red color, inside Brackets with Minus Sign, and Positive Numbers without Brackets and any Sign in Black Color, (which can be Blue or Even Green also).



                          [Black]#,##0.00_);[Red](-#,##0.00);0.00



                          #,##0.00_);[Red](-#,##0.00)



                          For example:



                          enter image description here



                          99,000.00



                          enter image description here



                          This Custom Format will show Negative Number with Minus Sing in Black Color without Brackets.



                          #,##0.00_) -99,000.00



                          For more details you can check these Web Sites:



                          https://exceljet.net/custom-number-formats



                          https://www.ablebits.com/office-addins-blog/2016/07/07/custom-excel-number-format/



                          Note, Color codes [Black] & [Red] are editable like, [Blue] or [Green].







                          share|improve this answer














                          share|improve this answer



                          share|improve this answer








                          edited 15 mins ago

























                          answered 25 mins ago









                          Rajesh S

                          3,5671522




                          3,5671522






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Super User!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.





                              Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                              Please pay close attention to the following guidance:


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1385410%2fwhere-can-i-find-the-grammar-guide-for-excel-format-syntax%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

                              Calculate evaluation metrics using cross_val_predict sklearn

                              Insert data from modal to MySQL (multiple modal on website)