Question

how do you apply date and time formatting to a cell?
select the row you wish to format and then on the home tab, in the text group, open the font format drop - down list and choose which formatting you want.
select the cell you wish to format and then on the home tab, in the number group, open the number format drop - down list and choose which formatting you want.
select the row you wish to format and then on the home tab, in the text group, open the font format drop - down list and choose which formatting you want.
select the aisle you wish to format and then on the home tab, in the paragraph group, open the paragraph format drop - down list and choose which formatting you want.

Explanation:

To apply date and time formatting to a cell, you need to select the cell (not the row or aisle). Date and time formatting is related to number formatting (as dates and times are often stored as numbers in spreadsheets). The correct steps involve using the Number group on the Home tab and the Number Format drop - down list.

Answer:

Select the cell you wish to format and then on the Home tab, in the Number group, open the Number Format drop - down list and choose which formatting you want.