Course Content
Excel Essentials
Excel Essentials
Formatting Numbers
In this chapter, we'll delve into formatting techniques that enhance the presentation and readability of numeric data in Excel.
We'll cover how to format numbers as currency, percentages, and dates, as well as how to create custom number formats tailored to specific needs.
Key Points
- Use the Locale function in the Number Format menu to format dates to various styles and regional preferences;
- Format your numbers as a Currency in the Number Format menu;
- Change the Currency Symbol and the amount of Decimal places in your numbers;
- Create Custom Number Formats by selecting the Custom function;
- Utilise the Quick Access options in the Number group on the Home tab to adjust decimal places, apply main currency formats, percentages, and thousands separators.
Task
- Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Task
- Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Everything was clear?
Choose your plan
Formatting Numbers
In this chapter, we'll delve into formatting techniques that enhance the presentation and readability of numeric data in Excel.
We'll cover how to format numbers as currency, percentages, and dates, as well as how to create custom number formats tailored to specific needs.
Key Points
- Use the Locale function in the Number Format menu to format dates to various styles and regional preferences;
- Format your numbers as a Currency in the Number Format menu;
- Change the Currency Symbol and the amount of Decimal places in your numbers;
- Create Custom Number Formats by selecting the Custom function;
- Utilise the Quick Access options in the Number group on the Home tab to adjust decimal places, apply main currency formats, percentages, and thousands separators.
Task
- Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Task
- Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Everything was clear?
Choose your plan
Formatting Numbers
In this chapter, we'll delve into formatting techniques that enhance the presentation and readability of numeric data in Excel.
We'll cover how to format numbers as currency, percentages, and dates, as well as how to create custom number formats tailored to specific needs.
Key Points
- Use the Locale function in the Number Format menu to format dates to various styles and regional preferences;
- Format your numbers as a Currency in the Number Format menu;
- Change the Currency Symbol and the amount of Decimal places in your numbers;
- Create Custom Number Formats by selecting the Custom function;
- Utilise the Quick Access options in the Number group on the Home tab to adjust decimal places, apply main currency formats, percentages, and thousands separators.
Task
- Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Task
- Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.
Everything was clear?
In this chapter, we'll delve into formatting techniques that enhance the presentation and readability of numeric data in Excel.
We'll cover how to format numbers as currency, percentages, and dates, as well as how to create custom number formats tailored to specific needs.
Key Points
- Use the Locale function in the Number Format menu to format dates to various styles and regional preferences;
- Format your numbers as a Currency in the Number Format menu;
- Change the Currency Symbol and the amount of Decimal places in your numbers;
- Create Custom Number Formats by selecting the Custom function;
- Utilise the Quick Access options in the Number group on the Home tab to adjust decimal places, apply main currency formats, percentages, and thousands separators.
Task
- Select cells
B12
toB18
. Go to Number section then More Number Formats and choose English (US). - Select cells
C20
toI21
. Go to Number section then Number Format. Click Currency and select the dollar symbol. - Select cells
C12
toI18
. Right-click on them and choose Format Cells. Go to the Number tab and select Custom. In the Type field, enter0.00
.