Basic Excel - Formatting the Date

Formatting the Date

 

1. Click on the cell that you want to put the date in

2.Go to the Number Format Group

3.Click on the down arrow located next to general.

 

4.Click on Long Date

5. Start typing the date in the cell

6.Click outside the cell. The format of the date has changed. You can see in the equations bar what you originally typed.   

Pre-setting the Date

 

 

1. Hold down the left mouse button and drag to highlight multiple cells.

2.Go to the Number Format Group

3.Click on the down arrow located next to general.

 

4.Click on Long Date. The cells highlighted in step 1 are now pre-set to the long date format. each time that you type a shorthand date it will appear as a long date.

To view more options click on the general down arrow and click on more number formats.

 

Under the list of categories select date. There is a list of possible choices under type. Click on the one you want and then click ok.