Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

Unit 5: Formatting worksheets > Topic C: Formatting numbers - Pg. 110

5 ­ 20 Excel 2007: Basic Topic C: Formatting numbers This topic covers the following Microsoft Certified Application Specialist exam objective for Excel 2007. # 2.3.1 Objective Apply number formats Format the values in the cell with a specified number of decimal places Format the values in the cell as a date Number formats Explanation Numbers, including date and time, can be displayed in many different formats. The actual cell value is not affected when you apply number formatting. The Number group Dollar signs ($), percent signs (%), and the number of decimal places are examples of number formatting. By using number formats, you can make your worksheets easier to understand and call attention to specific data. The Number group, shown in Exhibit 5-6, provides several tools for formatting numbers.