Where can I find the grammar guide for Excel format syntax? [closed]












19















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















closed as off-topic by Run5k, Twisty Impersonator, music2myear, DavidPostill Dec 25 '18 at 13:31


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Run5k, Twisty Impersonator, music2myear, DavidPostill

If this question can be reworded to fit the rules in the help center, please edit the question.









  • 1





    Check out superuser.com/q/1262919/774984 for more info on colours available to use

    – PeterH
    Dec 18 '18 at 8:17
















19















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















closed as off-topic by Run5k, Twisty Impersonator, music2myear, DavidPostill Dec 25 '18 at 13:31


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Run5k, Twisty Impersonator, music2myear, DavidPostill

If this question can be reworded to fit the rules in the help center, please edit the question.









  • 1





    Check out superuser.com/q/1262919/774984 for more info on colours available to use

    – PeterH
    Dec 18 '18 at 8:17














19












19








19


5






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








edited Dec 18 '18 at 6:41









Peter Mortensen

8,351166185




8,351166185










asked Dec 18 '18 at 2:39









athosathos

83271838




83271838




closed as off-topic by Run5k, Twisty Impersonator, music2myear, DavidPostill Dec 25 '18 at 13:31


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Run5k, Twisty Impersonator, music2myear, DavidPostill

If this question can be reworded to fit the rules in the help center, please edit the question.




closed as off-topic by Run5k, Twisty Impersonator, music2myear, DavidPostill Dec 25 '18 at 13:31


This question appears to be off-topic. The users who voted to close gave this specific reason:


  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Run5k, Twisty Impersonator, music2myear, DavidPostill

If this question can be reworded to fit the rules in the help center, please edit the question.








  • 1





    Check out superuser.com/q/1262919/774984 for more info on colours available to use

    – PeterH
    Dec 18 '18 at 8:17














  • 1





    Check out superuser.com/q/1262919/774984 for more info on colours available to use

    – PeterH
    Dec 18 '18 at 8:17








1




1





Check out superuser.com/q/1262919/774984 for more info on colours available to use

– PeterH
Dec 18 '18 at 8:17





Check out superuser.com/q/1262919/774984 for more info on colours available to use

– PeterH
Dec 18 '18 at 8:17










2 Answers
2






active

oldest

votes


















20














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


























  • Who felt the need to downvote this? Can you please leave a comment with your reasoning?

    – teylyn
    Dec 23 '18 at 21:37



















4














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 and should like, [Blue] or [Green].






share|improve this answer


























  • Write you concern, Why down voted this post?

    – Rajesh S
    Dec 23 '18 at 6:00


















2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes









20














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


























  • Who felt the need to downvote this? Can you please leave a comment with your reasoning?

    – teylyn
    Dec 23 '18 at 21:37
















20














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


























  • Who felt the need to downvote this? Can you please leave a comment with your reasoning?

    – teylyn
    Dec 23 '18 at 21:37














20












20








20







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








edited Dec 18 '18 at 8:46









eirikdaude

6082620




6082620










answered Dec 18 '18 at 3:24









teylynteylyn

17k22539




17k22539













  • Who felt the need to downvote this? Can you please leave a comment with your reasoning?

    – teylyn
    Dec 23 '18 at 21:37



















  • Who felt the need to downvote this? Can you please leave a comment with your reasoning?

    – teylyn
    Dec 23 '18 at 21:37

















Who felt the need to downvote this? Can you please leave a comment with your reasoning?

– teylyn
Dec 23 '18 at 21:37





Who felt the need to downvote this? Can you please leave a comment with your reasoning?

– teylyn
Dec 23 '18 at 21:37













4














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 and should like, [Blue] or [Green].






share|improve this answer


























  • Write you concern, Why down voted this post?

    – Rajesh S
    Dec 23 '18 at 6:00
















4














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 and should like, [Blue] or [Green].






share|improve this answer


























  • Write you concern, Why down voted this post?

    – Rajesh S
    Dec 23 '18 at 6:00














4












4








4







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 and should 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 and should like, [Blue] or [Green].







share|improve this answer














share|improve this answer



share|improve this answer








edited Dec 18 '18 at 7:47

























answered Dec 18 '18 at 6:03









Rajesh SRajesh S

1




1













  • Write you concern, Why down voted this post?

    – Rajesh S
    Dec 23 '18 at 6:00



















  • Write you concern, Why down voted this post?

    – Rajesh S
    Dec 23 '18 at 6:00

















Write you concern, Why down voted this post?

– Rajesh S
Dec 23 '18 at 6:00





Write you concern, Why down voted this post?

– Rajesh S
Dec 23 '18 at 6:00



Popular posts from this blog

Plaza Victoria

Puebla de Zaragoza

Musa