How to Change the Date Format in Excel 2010

Microsoft Excel 2010 is pretty good at recognizing data that fit into certain criteria and converting that data to the appropriate format.

One case where this is particularly true is with dates. If you enter anything that could be construed by Excel as a date, it will convert it to the currently selected date format.

However, depending on your needs, geographical location, and personal preferences, the format that Excel selects may not be your personal preference.

Fortunately, you can learn how to change the date format in Excel 2010 by selecting from one of several different date cell formats.

Once you have chosen a date format and applied it to either an entire row, column, or cell, then Excel will always display dates in that cell with the format that you selected.

Change How Excel 2010 Displays Dates

The nice thing about working with dates in Excel 2010 is that they are all natively stored in the same format. Therefore, when you apply a format change to a group of cells, they will all automatically take the new format, without you needing to go back and correct mistaken values.

Step 1: Begin by opening the Excel file that contains the dates for which you wish to change the format.

Step 2: Select the tab at the bottom of the window to display the worksheet with the dates that you want to reformat.

Step 3: Use your mouse to select the cell, group of cells, column or row containing the dates that you want to reformat.

highlight the desired cells

Step 4: Right-click one of the highlighted cells, then choose Format Cells.

how to change the date format in Excel 2010

Step 5: Click the Number tab at the top of the window, if it is not already selected.

Step 6: Click the Date option in the Category section at the left side of the window.

Step 7: Click the desired date format from the Type section at the center of the window.

choose new date format

Step 8: Click the OK button at the bottom of the window.

Now that you know how to change the date format in Excel 2010 you will be able to change date in your spreadsheets so that they look the way that you want them to.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Leave a Comment