{"id":1013,"date":"2017-06-29T21:16:29","date_gmt":"2017-06-29T21:16:29","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=1013"},"modified":"2024-05-16T19:08:16","modified_gmt":"2024-05-16T19:08:16","slug":"cell-format","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/cell-format\/","title":{"raw":"Cell Format","rendered":"Cell Format"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Change cell format.<\/li>\r\n<\/ul>\r\n<\/div>\r\nAs mentioned previously, Excel will default to certain styles when you create a new worksheet. In particular, this includes the way that numbers are displayed and whether or not commas are automatically included. In this section, we will take a look at changing these defaults.\r\n\r\nWhen you type numbers into an Excel workbook, it will often default to a specific format. For example, if you type \u201c12\/15\/17,\u201d Excel will convert this to read \u201c12\/15\/2017,\u201d assuming you were entering month, day, and abbreviated year. Similarly, \u201c3\/4\u201d will display at \u201c4-Mar,\u201d the fourth day of March. However, it is possible that you may have been entering fractions, so \u201c3\/4\u201d was meant to indicate three-quarters instead.\r\n\r\nIf this is the case, you will need to format your cells to properly display the information you are entering. When possible, consider formatting your cells before you enter the data. Otherwise, Excel may convert some of the entries and you will need to re-enter that information.\r\n<h2>Method 1<\/h2>\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29185550\/defaultcelldisplays1.png\"><img class=\"aligncenter wp-image-1014\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29185550\/defaultcelldisplays1.png\" alt=\"A blank Microsoft Excel sheet is open. There are three numbers each representing a different aspect of the sheet. The first number is green and shows a box which is highlighting a section of cells that have been selected. The second number is orange and next to it as an arrow that points to the format dropdown menu. The third number is pink and has an arrow next to it pointing at the format cells feature in the format dropdown menu.\" width=\"800\" height=\"583\" \/><\/a>\r\n<ol>\r\n \t<li>Begin by highlighting the cells you plan to use.<\/li>\r\n \t<li>Select the Format dropdown from the Cells group of the ribbon.<\/li>\r\n \t<li>Select the Format cells option at the bottom of the dropdown menu.<\/li>\r\n<\/ol>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/541fdfeb-e4a5-4add-b2f9-bb1c9a37d378\r\n\r\n<\/div>\r\nThere are several available format options for cells in Excel. When you select one, Excel will provide you with a description and examples of how the information will display in the cells.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29201422\/defaultcelldisplays2.png\"><img class=\"aligncenter wp-image-1017\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29201422\/defaultcelldisplays2.png\" alt=\"A format cell dialog box is open.\" width=\"600\" height=\"522\" \/><\/a>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/3aad7a5d-4677-4f0e-b665-6c3fb6c997d1\r\n\r\n<\/div>\r\n<h2>Method 2<\/h2>\r\nYou can perform the same actions using the \u201cNumber\u201d group in the ribbon. In this case, you simply select the cell format you wish to apply using the dropdown menu.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211132\/defaultcelldisplays3.png\"><img class=\"aligncenter wp-image-1018\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211132\/defaultcelldisplays3.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green arrow pointing at a green box showing where the number group option is.\" width=\"800\" height=\"596\" \/><\/a>","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Change cell format.<\/li>\n<\/ul>\n<\/div>\n<p>As mentioned previously, Excel will default to certain styles when you create a new worksheet. In particular, this includes the way that numbers are displayed and whether or not commas are automatically included. In this section, we will take a look at changing these defaults.<\/p>\n<p>When you type numbers into an Excel workbook, it will often default to a specific format. For example, if you type \u201c12\/15\/17,\u201d Excel will convert this to read \u201c12\/15\/2017,\u201d assuming you were entering month, day, and abbreviated year. Similarly, \u201c3\/4\u201d will display at \u201c4-Mar,\u201d the fourth day of March. However, it is possible that you may have been entering fractions, so \u201c3\/4\u201d was meant to indicate three-quarters instead.<\/p>\n<p>If this is the case, you will need to format your cells to properly display the information you are entering. When possible, consider formatting your cells before you enter the data. Otherwise, Excel may convert some of the entries and you will need to re-enter that information.<\/p>\n<h2>Method 1<\/h2>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29185550\/defaultcelldisplays1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1014\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29185550\/defaultcelldisplays1.png\" alt=\"A blank Microsoft Excel sheet is open. There are three numbers each representing a different aspect of the sheet. The first number is green and shows a box which is highlighting a section of cells that have been selected. The second number is orange and next to it as an arrow that points to the format dropdown menu. The third number is pink and has an arrow next to it pointing at the format cells feature in the format dropdown menu.\" width=\"800\" height=\"583\" \/><\/a><\/p>\n<ol>\n<li>Begin by highlighting the cells you plan to use.<\/li>\n<li>Select the Format dropdown from the Cells group of the ribbon.<\/li>\n<li>Select the Format cells option at the bottom of the dropdown menu.<\/li>\n<\/ol>\n<div class=\"textbox tryit\">\n<h3>Practice question<\/h3>\n<p>\t<iframe id=\"assessment_practice_541fdfeb-e4a5-4add-b2f9-bb1c9a37d378\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/541fdfeb-e4a5-4add-b2f9-bb1c9a37d378?iframe_resize_id=assessment_practice_id_541fdfeb-e4a5-4add-b2f9-bb1c9a37d378\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>There are several available format options for cells in Excel. When you select one, Excel will provide you with a description and examples of how the information will display in the cells.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29201422\/defaultcelldisplays2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1017\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29201422\/defaultcelldisplays2.png\" alt=\"A format cell dialog box is open.\" width=\"600\" height=\"522\" \/><\/a><\/p>\n<div class=\"textbox tryit\">\n<h3>Practice question<\/h3>\n<p>\t<iframe id=\"assessment_practice_3aad7a5d-4677-4f0e-b665-6c3fb6c997d1\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/3aad7a5d-4677-4f0e-b665-6c3fb6c997d1?iframe_resize_id=assessment_practice_id_3aad7a5d-4677-4f0e-b665-6c3fb6c997d1\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Method 2<\/h2>\n<p>You can perform the same actions using the \u201cNumber\u201d group in the ribbon. In this case, you simply select the cell format you wish to apply using the dropdown menu.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211132\/defaultcelldisplays3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1018\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29211132\/defaultcelldisplays3.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green arrow pointing at a green box showing where the number group option is.\" width=\"800\" height=\"596\" \/><\/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-1013\">\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>Cell Format. <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":20,"menu_order":8,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Cell Format\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"8189fb51-8af6-4f40-9be4-7acba86b12bc, 763bfcca-27d0-4bd7-99a7-55050abec477","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-1013","chapter","type-chapter","status-publish","hentry"],"part":975,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":16,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1013\/revisions"}],"predecessor-version":[{"id":5811,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1013\/revisions\/5811"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/975"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1013\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=1013"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=1013"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=1013"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=1013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}