how to change text dates (03082007) to mm/dd/yyyy (03/08/2007
G Gord Dibben Mar 8, 2007 #2 Data>Text to Columns>Next>Next>Column Data Format>Date. MDY or DMY Gord Dibben MS Excel MVP
