date

Copper Contributor

How Can I change number to date?

 

 

 

2 Replies

Hoe can I change number to date in the cell

 

Hi @Maria1950 

 

I merged your duplicate questions to be just one.

 

In Excel, dates are numbers using a specific format.  The numbers start with the 1st January 1900, which as a General format is a 1.

You can find the standard date format for your computer's region in the Number Format dropdown on the Home ribbon. 

 

Select the cell with the number, then select the formatting drop-down and select a date format. For more options, open the Format dialog (for example with Ctrl-1) and look on the Numbers tab.

 

If that does not give you the desired date, please post a few numbers you want to show as dates and let us know what you would like the numbers to be as dates.