Chat with us, powered by LiveChat

Format Numbers and Dates

How to Format Numbers and Dates in Google Sheets

Format Numbers and Dates

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

  1. Select a cell or cell range.
  2. Click the Format as Currency button.
    How to Apply date format in Google Sheets.

The currency formatting is applied, adding a currency symbol as well as displaying two decimal places.

Apply Date Format

  1. Select a cell or cell range.
  2. Click the More Formats button.

    A menu with more number formats appears, where we can choose from additional number, currency, and date formats.

  3. Select Date.
    How to Apply date format in Google Sheets.

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.

  1. Select a cell or cell range.
  2. Click Format on the menu bar.
  3. Select Number.
  4. Select More Formats.
  5. Select More date and time formats.
    How to Apply a custom date and time format in Google Sheets.

    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.

  6. Select a preset, or customize the date and time fields.
  7. Click Apply.
    How to select a preset in Google Sheets.

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.

  1. Select a cell or cell range.
  2. Click Format on the menu bar.
  3. Select Number.
  4. Select More Formats.
  5. Select Custom Number Format.
    How to create a custom number format in Google Sheets.

    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.

  6. Create a number format using the available placeholder characters.
  7. Click Apply.
    How to create a custom number format in Google Sheets.

The cells are updated to the new custom number format, and the format is saved for future use.

FREE Quick Reference

Click to Download