Chapter 2. FORMATTING A WORKSHEET
Using the Ribbon to Format Numbers
By applying formatting, you can change the way numbers display. For example, you can use Excel's formatting options to tell Excel you want to separate thousands or show decimal places. Formatting makes your data easier to read and helps you conform to company, country, or industry standards. Excel provides a variety of options for formatting numbers.
When you type numbers into a cell, in most instances they appear in the format you type them. However, if the number has decimal places and is too long to fit in the cell, Excel rounds the number. If the number is longer than 12 digits, Excel displays the number in scientific notation. If the number has leading or trailing zeros, Excel ...
Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
