Select the range of dates which needs to be corrected. From menu DataText to
Columns will populate the 'Convert Text to Columns Wizard' Hit NextNext will
take you to Step 3 of 3 of the Wizard. From Column Data format select Date
and select the date format in which your data is (DMY).Hit Finish. MSExcel
will now convert the dates to the default date format of your computer.

If this post helps click Yes
---------------
Jacob Skaria


"MN" wrote:

Hi- I have been read all instruction to convert to date but none of them
working so please help:
I have a cell format as general like: 1102005 I want to convert to format
mm/dd/yyyy
I did try DATE, and DATEVALUE function but not working?
Like:
=DATE(VALUE(LEFT(A1,2)),VALUE(MID(A1,3,2)),VALUE(R IGHT(A1,4)))
or
=DATE(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,4))
:-((
Thanks you inadvange