Chat with us, powered by LiveChat
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

Free to distribute with our compliments; we hope you will consider our paid training.