How to Reformat a Date in Excel. When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells ...

Select all the cells you want to modify, and right-click on them. Select Format Cells. Go to the Number tab. In the Category list, click Date. Under the Type list, choose the date format you want on ...

With the dates selected (C3:C37), click the Home tab, click Conditional Formatting, and then choose New Rule from the dropdown (Figure B). Excel opens the new Conditional Formatting pane to the right.

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.