Text to Date function

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

 

[T. Valko]

Try this:

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

 

[CS]

Thank you very much.

Try this:

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

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you very much.