How do I convert a number to a date format

C

CTausch

I accedentally changed a column of dates to numbers, and now need to convert
the serialized numbers back into dates... any ideas?
 
C

ClaireView

Right click on the cell, choose Format Cells, choose the Number tab, choose
Date, find the way you want the date displayed, then OK.
 
M

Myrna Larson

You didn't change the data; you only changed the format. "Under the hood"
dates are stored as the number of days that have elapsed since Dec 31, 1899,
so today is 38,271.

Change the format back to a date format.
 
Top