• support@answerspoint.com

how to change date format in excel sheet


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.



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 5 years ago
  • Community  wiki

Your Answer

    Facebook Share        
  • asked 5 years ago
  • viewed 1736 times
  • active 5 years ago

Best Rated Questions