• support@answerspoint.com

how to change date format in excel sheet

1903

If i Want to change default date format in Ms-Excel, How we can pick a different one in Excel, like August 2, 2017 or 2/8/17, and how i can also create my own custom format in Excel.

1Answer


0

Choose from a list of date formats

Select the cells you want to change format.

1. Press CTRL+1.

2. On a Mac, press Control+1 or Command+1.

3. In the Format Cells box, click the Number tab.

4. In the Category list, click Date.

 

  • answered 6 years ago
  • Community  wiki

Your Answer

    Facebook Share