How to Format Numbers and Dates in Google Sheets
To make a spreadsheet easier to read, you can apply a number format to cells that contain dates, numbers, and currency values.
The currency formatting is applied, adding a currency symbol as well as displaying two decimal places.
A menu with more number formats appears, where we can choose from additional number, currency, and date formats.
If none of the built-in currency or date formats are exactly what you're looking for, you can customize them.
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.
The new date format is applied.
You can create your own custom number format if you have a specific format you are going to use frequently.
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.
The cells are updated to the new custom number format, and the format is saved for future use.