Sorry, of course !

MDY - during the text to columns conversion is defining the input data, =
=

yours need to be DMY

What you see afterwards depends on the locale/date style that you are =

using.
In your case M/DD/YYYY

BTW you can't have a format type of "*3/14/01" or did you mean that was =
=

the actual data ?

Steve


On Tue, 25 Jul 2006 13:44:52 +0100, aposatsk =

<aposatsk.2bi4h5_1153831513.767@excelforum-nospam.com> wrote:

>
> Well we're getting closer but there are still problems. When i choose
> MDY, dates such as 30/3/2005 *do not* change to 3/30/2005. But when i
> choose DMY, 30/3/2005 *does* changes to 3/30/2005.
>
> Gord Dibben Wrote:
>> If the date was entered as text, which I think it was, re-formatting
>> will not
>> change it a date.
>>
>> Try Data>Text to Columns>Next>Next>Column Data Format>Date>DMY and
>> Finish.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Mon, 24 Jul 2006 15:18:27 -0400, aposatsk
>> <aposatsk.2bgs3j_1153768811.4868@excelforum-nospam.com> wrote:
>>
>> >
>> >The list is formatted as "Date". The exact format type is "
>> *3/14/2001"
>> > I am not sure what the * signifies.
>> >
>> >If i change the type to, say, 3/14/01, some days convert to this
>> format
>> >but others with double-digit days _do_not_ change *!!*
>
>