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

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

• To insert the current time, press + ; (semi-colon).

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

plzz add me as brain list

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).

=NOW(): Current date and time (varies)

=TODAY(): Current date (varies)

Formula: Description (Result)