how to change date format in excel sheet

824

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

Your Answer

    Facebook Share        
       
  • asked 2 years ago
  • viewed 824 times
  • active 2 years ago

Hot Questions