How do I convert a number to a date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I accedentally changed a column of dates to numbers, and now need to convert
the serialized numbers back into dates... any ideas?
 
Right click on the cell, choose Format Cells, choose the Number tab, choose
Date, find the way you want the date displayed, then OK.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
How to convert or transpose variable list into table 0
Convert number to date value 8
Need to open eer file without converting 8-7440 to a date? 1
converting date to text 2
Convert Date to Text 2
Columns formatted As Dates Are Exported as a Number to Text 1
Convert date to text 6

Back
Top