Excel Date Formatting

Access the Date Format menu from the View tab

Use the Replace function to change the date format

Select the cell containing the date, click on the Format drop-down button, and choose Format Cells option (correct)

Type the new format directly into the cell

Change cell contents directly from the Formula Bar

Replace cell contents or use Edit mode (correct)

Copy and paste cell contents

Delete and re-enter cell contents

Category list on the Number tab in Format Cells dialog box (correct)

In the Date Format submenu

In the View menu on the Excel toolbar

Under the Home tab in Excel settings

<p>The Cancel and Enter buttons become active on the left of the Formula Bar</p> Signup and view all the answers

<p>Press either the Enter key or Enter button on the Formula Bar</p> Signup and view all the answers