Sure, here are the steps to format the dates in Excel:

1. Open your Excel workbook and navigate to the worksheet where you want to change the date format.
2. Select the range of cells you want to format. In your case, it would be F18:F1017 for 'ReqDate' and G18:G1017 for 'WokDate'.
3. Right-click on the selected range and choose "Format Cells" from the context menu.
4. In the Format Cells dialog box, click on the "Number" tab and then select "Custom" from the category list.
5. In the "Type" input field, enter the custom date format as "dd-mmm-yy".
6. Click "OK" to close the dialog box.

The dates in the selected cells will now be displayed in the "dd-mmm-yy" format.

Question

Sure, here are the steps to format the dates in Excel:

1. Open your Excel workbook and navigate to the worksheet where you want to change the date format.
2. Select the range of cells you want to format. In your case, it would be F18:F1017 for 'ReqDate' and G18:G1017 for 'WokDate'.
3. Right-click on the selected range and choose "Format Cells" from the context menu.
4. In the Format Cells dialog box, click on the "Number" tab and then select "Custom" from the category list.
5. In the "Type" input field, enter the custom date format as "dd-mmm-yy".
6. Click "OK" to close the dialog box.

The dates in the selected cells will now be displayed in the "dd-mmm-yy" format.

Knowee AI · Accepted Answer

Sure, here are the steps to format the dates in Excel:

1. Open your Excel workbook and navigate to the worksheet where you want to change the date format.
2. Select the range of cells you want to format. In your case, it would be F18:F1017 for 'ReqDate' and G18:G1017 for 'WokDate'.
3. Right-click on the selected range and choose "Format Cells" from the context menu.
4. In the Format Cells dialog box, click on the "Number" tab and then select "Custom" from the category list.
5. In the "Type" input field, enter the custom date format as "dd-mmm-yy".
6. Click "OK" to close the dialog box.

The dates in the selected cells will now be displayed in the "dd-mmm-yy" format.

Use a Custom Number Format to display the dates in the ‘ReqDate’ (Column F in cells F18:F1017) and ‘WokDate’ (Column G in cells G18: G1017) as “dd-mmm-yy”

Question

Solution

Similar Questions

Upgrade your grade with Knowee