How to set date and time in Excel2010

how to set date and time in Excel2010

Step 1th, open the Excel2010 workbook window and select the cells you want to format the date and time numbers in. Right-click the selected cell and select Format Cells on the open shortcut menu, as described in Figure 1.

Excel2010

Step 2nd, in the Format Cells dialog box that opens, switch to the Number tab and select the Date or Time option in the Category list. Then select the date or time format you want in the list of date or time types, as shown in Figure 2.