<div>
<div class="ns-school-defn2">
<h3>Learning Objectives</h3>
<ul>
<li>Change cell format.</li>
</ul>
</div>
<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>
<p>When you type numbers into an Excel workbook, it will often default to a specific format. For example, if you type “12/15/17,” Excel will convert this to read “12/15/2017,” assuming you were entering month, day, and abbreviated year. Similarly, “3/4” will display at “4-Mar,” the fourth day of March. However, it is possible that you may have been entering fractions, so “3/4” was meant to indicate three-quarters instead.</p>
<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>
<h2>Method 1</h2>
<div><a href="https://data.ulearngo.com/assets/30b1a83c-f2e2-4c04-bcb0-d7a128d537e2"><img 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." height="583" src="https://data.ulearngo.com/assets/30b1a83c-f2e2-4c04-bcb0-d7a128d537e2" srcset="https://data.ulearngo.com/assets/46a29636-42bd-4639-84b6-4c9127780171 975w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29185550/defaultcelldisplays1-300x218.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29185550/defaultcelldisplays1-768x559.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29185550/defaultcelldisplays1-65x47.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29185550/defaultcelldisplays1-225x164.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29185550/defaultcelldisplays1-350x255.png 350w" width="800"/></a></div>
<ol>
<li>Begin by highlighting the cells you plan to use.</li>
<li>Select the Format dropdown from the Cells group of the ribbon.</li>
<li>Select the Format cells option at the bottom of the dropdown menu.</li>
</ol>
<div class="ns-school-defn2">
<h3>Practice question</h3>
<div class="video-container">
<div class="responsive-video"><iframe frameborder="0" src="https://assessments.lumenlearning.com/assessments/load?assessment_id=5360&amp;embed=1&amp;external_user_id=&amp;external_context_id=&amp;iframe_resize_id=lumen_assessment_5360"></iframe></div>
</div>
</div>
<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>
<div><a href="https://data.ulearngo.com/assets/7ef611bf-6ec4-4a04-9536-c133aa6b2ed0"><img alt="A format cell dialog box is open." height="522" src="https://data.ulearngo.com/assets/7ef611bf-6ec4-4a04-9536-c133aa6b2ed0" srcset="https://data.ulearngo.com/assets/9c761c4d-6593-4198-b01e-aa3902b613ff 846w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29201422/defaultcelldisplays2-300x261.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29201422/defaultcelldisplays2-768x668.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29201422/defaultcelldisplays2-65x57.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29201422/defaultcelldisplays2-225x196.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29201422/defaultcelldisplays2-350x304.png 350w" width="600"/></a></div>
<div class="ns-school-defn2">
<h3>Practice question</h3>
<div class="video-container">
<div class="responsive-video"><iframe frameborder="0" src="https://assessments.lumenlearning.com/assessments/load?assessment_id=5361&amp;embed=1&amp;external_user_id=&amp;external_context_id=&amp;iframe_resize_id=lumen_assessment_5361"></iframe></div>
</div>
</div>
<h2>Method 2</h2>
<p>You can perform the same actions using the “Number” group in the ribbon. In this case, you simply select the cell format you wish to apply using the dropdown menu.</p>
<div><a href="https://data.ulearngo.com/assets/6106e95c-32e5-4729-84b4-4b23b4be3fee"><img 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." height="596" src="https://data.ulearngo.com/assets/6106e95c-32e5-4729-84b4-4b23b4be3fee" srcset="https://data.ulearngo.com/assets/e5244de9-5b0f-47f8-abd4-b12ce2f09ea9 965w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29211132/defaultcelldisplays3-300x224.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29211132/defaultcelldisplays3-768x572.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29211132/defaultcelldisplays3-65x48.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29211132/defaultcelldisplays3-225x168.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/06/29211132/defaultcelldisplays3-350x261.png 350w" width="800"/></a></div>
</div>

f81e5c79-392c-4944-a83a-d60f1aeed2c9

Cell Format

Computer Studies deals with general knowledge of computer and computing terminologies and technologies. It concentrates on fostering interest and raising confidence in the use of computing.

Computer Studies

Learn how to create and format workbooks, enter and rearrange data, apply table and cell styles, use functions, create charts, apply conditional formatting, and analyze trends in Microsoft Excel.


Cell Format

Track Your Learning Progress

Earlier discussion