Question

How can you enter date and time together in a cell?​

Answer 1

Answer: Insert a static date or time into an Excel cell

1. To insert the current date, press Ctrl+; (semi-colon).

2. To insert the current time, press Ctrl+Shift+; (semi-colon).

3. To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).

Explanation:

Answer 2

Answer:

To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon). To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).