Summary  
This chapter covers number formatting techniques such as applying currency, percentage, date, and custom numeric formats to data for clear presentation. It explains how to use built-in formats, adjust localization and decimal precision, and define custom format codes.

General domain of usage  
Financial reporting

**Number formatting** in Excel helps you present numeric data clearly and professionally by applying currency, percentage, date, and custom formats.

Task Template

Download Solution workbook

- Format dates according to regional standards via **Home** tab → **Number** group → **Number Format** → **More Number Formats...**, then choose the needed option;
- Change **Currency** via **Home** tab → **Number** group → **Number Format** → **More Number Formats...**;
- Create custom values via **Home** tab → **Number** group → **Number Format** → **More Number Formats...** → **Custom**;
- Alternatively, open **More Number Formats...** using the right-click menu → **Format Cells...**.

Dive into the world of Excel with this comprehensive video course, designed to take you from basic navigation to mastering functions and basic data analysis. Starting with foundational skills like data entry and cell formatting, you'll quickly progress to using powerful tools. Whether you're organizing large datasets, performing statistical analysis, or creating dynamic charts, this course equips you with the practical skills needed in today’s data-driven environment.

Number Formatting in Excel

Key Points

Essential Keyboard Shortcuts