How to Change Date Format in Excel Online and Google Sheets

By

Although Google Sheets and excel online are two of the best free online spreadsheet editing apps, you might not like some of their features. For example, the date format. If you don’t want to use the predefined date or time format, you can change them in Google Sheet and Excel Online. For your information, you don’t need to use an add-on or any third-party service to do this.

There’s no limit to what you can write or insert into an Excel spreadsheet. From writing simple text to image to date and time, you can add almost anything to your Excel file. When you add a date, it uses a predefined format. Even if you need a format like 02/08/2021, Excel Online and Google Sheets can use something else, like 08-02-2021. Sometimes you might not like such a change due to unfamiliarity. In such situations, you can follow this guide to use a custom or different date or time format in Google Sheets and Excel Online.

To change the date format in Google Sheets, follow these steps:

  1. Open Google Sheets on your browser.
  2. Click the date/time cell.
  3. Go to Format > Number.
  4. Select the Custom date and time option.
  5. Select a date/time format.
  6. Click it To apply button.

To learn more about these steps, keep reading.

First, you need to open Google Sheet on your browser. Then click on the cell, which displays the date and time.

After that click on the Format menu in the top menu bar, then select the Number option. Then select the Custom date and time option.

How to Change Date Format in Google Sheets and Excel Online

Here you will find a list of the different date and time formats. You can select an option you like and click the To apply button.

How to Change Date Format in Google Sheets and Excel Online

Once done, you can find the new format.

The above mentioned steps help you change the date or time format of a particular cell. However, if you want to apply the same change to all cells, you need to select the entire worksheet first. After that, you can follow the same method as above.

To change the date format in Excel Online, follow these steps:

  1. Open Excel Online on your computer.
  2. Right click on the date/time cell.
  3. Select the number format option.
  4. Go to Dated tongue.
  5. Select a date format you like.
  6. Click it Okay button.

Let’s see these steps in detail.

To get started, you need to open a spreadsheet in Excel Online. Next, right-click on the date/time cell and select the number format context menu option.

How to Change Date Format in Google Sheets and Excel Online

Once the window opens, proceed to the Dated tongue. Here you can find many options for dates. You can choose one according to your needs.

How to Change Date Format in Google Sheets and Excel Online

Then click on the Okay button to save the change.

For your information, you can visit the Time to also define a custom format for the time. Also, like Google Sheets, you can change the date and time format for all cells at once if you select the entire spreadsheet first.

Can I change the date format in Google Sheets?

Yes, you can change the date format in Google Sheets. To do this, you must first select the cell. Then go to Format > Number and select the Custom date and time option. After that, choose a format you like and click the To apply button. If you want to apply the change to the whole worksheet, you must select it first.

To change the date format in Excel 365, select the cell in your spreadsheet and navigate to Format > Format Cells. You can find this option in the House tongue. Then go to the Dated tab and select a format as desired. Finally, click on the Okay button to save the change.

That’s all! Hope this helped.

Read: How to prevent Excel from rounding numbers.

How to Change Date Format in Google Sheets and Excel Online

Leave a Comment

Your email address will not be published.

You may also like