Home How To How Do You Change Date Format in Excel?

How Do You Change Date Format in Excel?

by Geek Insider Staff

If you want to enter a date in your Excel spreadsheet, you can choose from the available formats or customize it. Depending on your settings, a date could appear as 10-Jan, January 10, 2022, 10 January, or 10/01/2022. This guide shows you how to input different date formats easily.

Change Date Format from The Format List.

The formats lists make changing dates easy as many formats are in this menu. 

  1. Highlight/select the cells you want to format.
  2. Right-click or Click Comman+1 /Ctrl+1.
  3. Click “Format Cells.”

Pastedgraphic. Png

  1. Select the “Numbers” tab
  2. Select “Date.” From the menu that appears. 
  3. Choose from the different date formats that will appear.

Pastedgraphic_1. Png

Create a Custom Date Format

  1. Highlight the cells you want to format.
  2. Right-click. 
  3. Open “Format Cells.” 

Pastedgraphic. Png

  1. Click “Numbers.”
  2. Select “Custom” from the category.

The default format will appear, meaning that any changes you make to the date will only apply to your customized setting. 

  1. Type your number format code under “Type” to alter the date.

Pastedgraphic_2. Png

Try out the different methods to change format in Excel to show date in your spreadsheet. 

You may also like

Leave a Comment