
To make a spreadsheet easier to read, you can apply a number format to cells that contain dates, numbers, and currency values.
Apply Currency Format
The currency formatting is applied, adding a currency symbol as well as displaying two decimal places.
Apply Date Format
- Select a cell or cell range.
- Click the More Formats button.
A menu with more number formats appears, where we can choose from additional number, currency, and date formats.
- Select Date.
Apply a Custom Date and Time Format
If none of the built-in currency or date formats are exactly what you're looking for, you can customize them.
- Select a cell or cell range.
- Click Format on the menu bar.
- Select Number.
- Select More Formats.
- Select More date and time formats.
Here, you can customize all aspects of the date format. You can select another preset from the list; modify the month, day, and year fields; or add more fields to the format.
- Select a preset, or customize the date and time fields.
- Click Apply.
The new date format is applied.
Create a Custom Number Format
You can create your own custom number format if you have a specific format you are going to use frequently.
- Select a cell or cell range.
- Click Format on the menu bar.
- Select Number.
- Select More Formats.
- Select Custom Number Format.
This dialog box displays a few examples, with special characters representing different ways for numbers to be formatted. To see a list of what each character means, click Help.
- Create a number format using the available placeholder characters.
- Click Apply.
The cells are updated to the new custom number format, and the format is saved for future use.