dates

[Guest]

how to change text dates (03082007) to mm/dd/yyyy (03/08/2007

 

[Gord Dibben]

Data>Text to Columns>Next>Next>Column Data Format>Date.

MDY or DMY


Gord Dibben MS Excel MVP