MS Excel date format yyyyddmm to mmddyyyy

[swaimdw]

Date reformatting - I have a column of dates in a worksheet that appear as ( yyyyddmm ) I need to convert this field to mmddyyyy but Excel does not recognize the format as a date, therefore Excel will not auto reformat the date unless I manually insert a hyphen between the items, ie yyyy-dd-mm. Any ideas as to how to how to take care of this?
Thanks
Darrell

 

[xlbo]

=value(right(A1,2) & "/" & mid(A1,5,2) & "/" & left(A1,4))
then format as mmddyyyy - should do the trick wher ehte "date" is in A1.....copy down an paste as values

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes