Text to Date function

  • Thread starter Thread starter CS
  • Start date Start date
C

CS

I have a row of Text
20071020
20070814

could anyone help me, these are supposed to be dates but have been put in as
text. I need to convert these to a short date 10/20/2007 etc. Any help would
be greatly appreciated.
 
Try this:

Select the data in question
Goto the menu Data>Text to Columns
Click Next twice
Column data format: Date>YMD
Finish
 
Back
Top