Question

Explain how we can convert a number into date and time​

Answer 1

Answer:

Select the cells that have the number that you want to convert into a date.

Click the 'Home' tab.

In the 'Number' group, click on the Number Formatting drop-down.

In the drop-down, select 'Long Date' or Short Date' option (based on what format would you want these numbers to be in) .

Hope you find this answer helpful.

Answer 2

Answer:

Select the cells that have the number that you want to convert into a date.Click The Home' tab.In the 'Number' group, click on the Number formatting drop-down.In the drop-down, select Long Date' or Short Date option (based on what format would you want these numbers to be in)