Converting numbers to dates in Excel

  • Thread starter Thread starter Juli-Kay
  • Start date Start date
J

Juli-Kay

I have a spreadsheet with dates entered as YYYYMMDD. For
example August 20, 2003 is entered as the number
20030820. Is there a way I can convert this number to a
date format?

Many thanks!
 
One way, select the column, do data>text to columns,
click Next twice, under column data format select Date and YMD,
click Finish
 
Thanks, Peo! I feel kinda stupid asking such a seemingly
simple question, but that's OK -- now at least I know how
to do it. Thanks again!

Juli-Kay
 
Back
Top