Hi there,

I a have a list of dates which have been imported as MM/DD/YYYY and
am having problems using text to columns in a macro to convert them t
DD/MM/YYYY.

When I do it manually from the data menu it works fine selecting th
data type as Date and MDY.

I can record this and then run the macro and it picks up the date
which are 07/24/05 but ignores the dates which are 08/02/05 (this is
August 05).

This is the script I am using:

Columns("I:I").Select
Selection.TextToColumns Destination:=Range("j1")
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True
Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False
FieldInfo _
:=Array(1, 3)

Can anyone help me?

Thanks
:confused

--
dipp
-----------------------------------------------------------------------
dippy's Profile: http://www.excelforum.com/member.php...fo&userid=2592
View this thread: http://www.excelforum.com/showthread.php?threadid=39291