Step 10 of 40: Comma Style Number Format & Setting Column Width
This step illustrates how to format numbers in cells to Comma Style using the Comma Style command. It also illustrates how to specify the width of a column using the Column Width command in Format drop-down menu.
In Step 10, start by selecting cells B3:C30. Choose Home | Comma Style. Click Home | Decrease Decimal twice. All amounts should appear as numerals, but if you see #### then use the AutoFit Column Width command again. Choose Home | Format | Column Width, enter 7.83 in the Column width field, and press OK. Make note of the column width for columns B:C. The width may vary. Apply the comma style and remove decimals from cells F3:G30 and J3:K30. Use steps 7-10 to set the widths of columns F:G and J:K to be the same as columns B:C.
TIP: Sometimes Excel presents numbers in scientifc notation when a column isn't wide enough. In other cases, it may return #### when a column is not wide enough to display a number.
Steps labeled YOUR TURN are reinforcing steps that present opportunities to apply concepts covered earlier in the assignment.
We're here to help
If you're stuck or confused, send a copy of your workbook by way of one of these methods:
• Share: Click the Share command in the upper-right hand corner of the Excel screen, choose Share again, and then share the workbook with support@studentsexcel.com.
• Upload: You can upload a copy of your workbook at www.studentsexcel.com/student-upload.
• Email: You can email your workbook as an attachment to support@studentsexcel.com.
Be sure to listen to the audio portion of the video as you work through the assignment. The presenter elaborates further on what is being presented on screen and will offer tips.