Excel Training: Date Formatting

For this example, dates have been entered into a table:

excel table dates png date formatting


To modify the format of these dates, select them then open the "Format Cells" window by right clicking.

Then select the suitable format from the "Date" category:

excel cell format dates png date formatting

And validate:

excel format dates date formatting

Text Orientation

You can change the text orientation from the "Alignment" tab in the "Format Cells" window or by clicking directly where indicated on this image:

excel text orientation date formatting

Then adapt the formatting to the new text orientation:

excel dates orientation date formatting

Customize a Format

If the desired format is not available among the various choices offered by "Format Cells", click on the "Custom" category and enter the desired format:

excel dates custom format date formatting

To obtain for example:

excel format date d mmmmm formatting