How to Change a Date Format in Excel 2007

By Craig Witt

Developed by Microsoft, the Excel 2007 spreadsheet application gives you the ability to create rows and columns of data, apply formatting to that data and generate a wide range of charts, graph, sorting mechanisms, functions and calculations. When you enter a set of letters or numbers that Excel 2007 interprets as a date, the program automatically converts the data into a pre-selected format. If you prefer to use an alternate combination, Excel allows you to do so. Once you know where to find this option, changing a date format in Excel 2007 becomes a very quick task.

Step 1

Open your Microsoft Excel 2007 spreadsheet and click on the cell containing the date-formatted data you wish to change. If you want to change the format for multiple cells, highlight all of the cells you want to edit.

Step 2

Right-click any highlighted cell and select the "Format Cells" option.

Step 3

Select the "Number" tab located at the top-left corner of the resulting dialog box.

Step 4

Look to the "Category" column on the left side of the dialog box and select the "Date" option.

Step 5

Select your preferred date format from the list of options presented in the "Type" column on the right side of the dialog box.

Step 6

Click "OK" to confirm the change.