Converting numbers to dates in Excel

[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!

 

[Peo Sjoblom]

One way, select the column, do data>text to columns,
click Next twice, under column data format select Date and YMD,
click Finish

 

[Juli-Kay]

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