Excel 2019/365: Formatting: The Number Group

Updated 2019-08-04

Objectives

·        Format numbers

·        Format dates

 

Note: Before doing any formatting commands, the cells must be selected (highlighted) first. Use the fat white plus sign to select cells.

 

Great tip: To copy an existing format, use the format painter button  on the Home tab.

Number Formatting

To make numbers look like this:

Do this

$12.34 (currency)

·       Click on the Home tab.

·       Click on the accounting number format button:  (gives 2 decimal places by default)

50% (percent)

·       Click on the Home tab.

·       Click on the percent style button:

12,345.67 (comma)

·       Click on the Home tab.

·       Click on the comma style button:

Anything else

Right-click on the cell(s), and choose Format Cells from the popup menu

 

To achieve this:

Do this:

Increase the number of decimal places

·       Click on the Home tab.

·       Click on the Increase Decimal button:

Decrease the number of decimal places

·       Click on the Home tab.

·       Click on the Decrease Decimal button:

There are also named number formats: