Abstract
Transcript
What is a number format?
Number formats are used to control the display of cell values that contain numeric data.
Let’s take a look.
Here you’ll find formats for currency, numbers, date, time, and more.
To apply a number format, just select one or more cells and choose a format.
Number formats only affect numbers; they have no effect on text.
Let’s format the rest of the values in our table.
When you have multiple cells selected, you’ll see the format of the active cell displayed.
Be aware that the active cell in a selection can vary, depending on how you select cells.
Most number formats have one or more options.
To set number format options, and to see all number formats, visit the Format Cells dialog box.
On the Number tab, you’ll find all the options available for each number format.
Let’s use the Format Cells dialog box to adjust the Fraction format.
To get our fraction to display correctly, let’s format it to use hundredths.
Finally, remember that number formats only affect the display of a cell value, not the value itself.
