On my copy of Excel 2002 that only works if the string of digits are 8
characters long.

It works for this:

11022005

It doesn't work for this:

1102005

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
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