Q14:-To enter date and time
together, separate them with
Answers
Answered by
9
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.
Similar questions