{"id":206,"date":"2022-12-01T20:31:34","date_gmt":"2022-12-01T20:31:34","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/comma-styles\/"},"modified":"2022-12-01T20:31:34","modified_gmt":"2022-12-01T20:31:34","slug":"comma-styles","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/comma-styles\/","title":{"raw":"Comma Styles","rendered":"Comma Styles"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Change comma style.<\/li>\n<\/ul>\n<\/div>\nAt times, you may also wish to use a specific comma style with numbers entered into an Excel worksheet. For example, you may wish \u201c1234\u201d to display as typed or with a comma like \u201c1,234.\u201d\n\nComma styles are easy to change in Excel using a quick select option in the Number group in the ribbon.\n<h2>Method 1<\/h2>\nWhen using the Format cell dropdown option from this area, select the \u201cUse 1000 Separator (,)\u201d option to include a comma. You can also choose if you would like any decimal places to be displayed in this same window.\n\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211256\/defaultcelldisplays4.png\"><img class=\"aligncenter wp-image-1019\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211256\/defaultcelldisplays4.png\" alt=\"A format cells dialog box is open. In the number tab the category has also been set as number. There is a green arrow pointing at the option to &quot;Use 1000 Separator.&quot;\" width=\"700\" height=\"609\"><\/a>\n<h2>Method 2<\/h2>\nThe easiest option to include a comma is simply to click on the Comma Style button in the Number group.\n\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211411\/defaultcelldisplays5.png\"><img class=\"aligncenter wp-image-1020\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211411\/defaultcelldisplays5.png\" alt=\"\" width=\"800\" height=\"595\"><\/a>\n\nWhen clicking the comma style button, the comma style default is to display numbers with a comma in the thousands place and include two decimal places (Ex: \"1200\" becomes \"1,200.00). This will also change the visible cell styles in the Style\u201d area of the ribbon so you can easily select different options for comma and display format.\n<div class=\"textbox tryit\">\n<h3>Practice question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/192d0d57-3ce6-483d-b297-8af7df94d12d\n\n<\/div>\nBelow are three different options for comma and display format.\n<ol>\n \t<li><strong>Comma<\/strong>: Comma with two decimal points<\/li>\n \t<li><strong>Comma [0]<\/strong>: Comma with no decimal points<\/li>\n \t<li><strong>Currency<\/strong>: Comma with two decimal points and a dollar sign<\/li>\n<\/ol>\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211527\/defaultcelldisplays6.png\"><img class=\"aligncenter wp-image-1021\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211527\/defaultcelldisplays6.png\" alt=\"A Microsoft Excel sheet is open with numbers in columns A1 through C4. In column A there is a green number 1 showing how this column has been formatted as a comma with two decimal points. In column B there is an orange 2, this column has been formatted with a comma with no decimal points. In the third column, column C there is a pink 3 showing how this column has been formatted as a comma with two decimal points and a dollar sign.\" width=\"800\" height=\"598\"><\/a>\n<div class=\"textbox tryit\">\n<h3>Practice question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/fa8c7309-416c-4755-aea2-dca9b12498db\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1vI8_KzAnSbJgzizUCenfBkWkGFf0XWOr5OQHabhuRdw\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Change comma style.<\/li>\n<\/ul>\n<\/div>\n<p>At times, you may also wish to use a specific comma style with numbers entered into an Excel worksheet. For example, you may wish \u201c1234\u201d to display as typed or with a comma like \u201c1,234.\u201d<\/p>\n<p>Comma styles are easy to change in Excel using a quick select option in the Number group in the ribbon.<\/p>\n<h2>Method 1<\/h2>\n<p>When using the Format cell dropdown option from this area, select the \u201cUse 1000 Separator (,)\u201d option to include a comma. You can also choose if you would like any decimal places to be displayed in this same window.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211256\/defaultcelldisplays4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1019\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211256\/defaultcelldisplays4.png\" alt=\"A format cells dialog box is open. In the number tab the category has also been set as number. There is a green arrow pointing at the option to &quot;Use 1000 Separator.&quot;\" width=\"700\" height=\"609\" \/><\/a><\/p>\n<h2>Method 2<\/h2>\n<p>The easiest option to include a comma is simply to click on the Comma Style button in the Number group.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211411\/defaultcelldisplays5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1020\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211411\/defaultcelldisplays5.png\" alt=\"\" width=\"800\" height=\"595\" \/><\/a><\/p>\n<p>When clicking the comma style button, the comma style default is to display numbers with a comma in the thousands place and include two decimal places (Ex: &#8220;1200&#8221; becomes &#8220;1,200.00). This will also change the visible cell styles in the Style\u201d area of the ribbon so you can easily select different options for comma and display format.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice question<\/h3>\n<p>\t<iframe id=\"assessment_practice_192d0d57-3ce6-483d-b297-8af7df94d12d\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/192d0d57-3ce6-483d-b297-8af7df94d12d?iframe_resize_id=assessment_practice_id_192d0d57-3ce6-483d-b297-8af7df94d12d\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>Below are three different options for comma and display format.<\/p>\n<ol>\n<li><strong>Comma<\/strong>: Comma with two decimal points<\/li>\n<li><strong>Comma [0]<\/strong>: Comma with no decimal points<\/li>\n<li><strong>Currency<\/strong>: Comma with two decimal points and a dollar sign<\/li>\n<\/ol>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211527\/defaultcelldisplays6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1021\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211527\/defaultcelldisplays6.png\" alt=\"A Microsoft Excel sheet is open with numbers in columns A1 through C4. In column A there is a green number 1 showing how this column has been formatted as a comma with two decimal points. In column B there is an orange 2, this column has been formatted with a comma with no decimal points. In the third column, column C there is a pink 3 showing how this column has been formatted as a comma with two decimal points and a dollar sign.\" width=\"800\" height=\"598\" \/><\/a><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice question<\/h3>\n<p>\t<iframe id=\"assessment_practice_fa8c7309-416c-4755-aea2-dca9b12498db\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/fa8c7309-416c-4755-aea2-dca9b12498db?iframe_resize_id=assessment_practice_id_fa8c7309-416c-4755-aea2-dca9b12498db\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1vI8_KzAnSbJgzizUCenfBkWkGFf0XWOr5OQHabhuRdw\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-206\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Comma Styles. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":503070,"menu_order":9,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Comma Styles\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"8189fb51-8af6-4f40-9be4-7acba86b12bc, 1385ff2a-97ff-4027-86be-84e9cf3c2cf1","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-206","chapter","type-chapter","status-publish","hentry"],"part":197,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/206\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/197"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/206\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=206"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=206"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=206"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}