Question

Q14:-To enter date and time
together, separate them with​

Answer 1

Answer:

Select the cell B1 and write the formula to extract date from cell A1.

=INT(A1), press enter.

Format this cell as “mm/dd/yyyy”

To format the cell, press the key “CTRL+1”

Format Cells dialog box will appear.