Text to Column, Changing date format

**danny2000** · 11-24-2007, 05:24 AM

Hi
Does anyone know how to replicate the function in VBA. If I have a column shown in mm/dd/yyyy date format but the computer I am using reads in mm/dd/yyyy format I select the whole column and then select Text to Columns and change the date format that way and the data changes to the dd/mm/yyyy format.

I don't want to change the computers settings.

Thanks.

**VBA Noob** · 11-24-2007, 06:02 AM

Maybe

Dim Rng As Range
Set Rng = Selection
 Rng.TextToColumns Destination:=Rng.Cells(1), DataType:=xlDelimited, _
        FieldInfo:=Array(1, 2)

VBA Noob

**danny2000** · 11-24-2007, 09:27 PM

Thanks, though I'm not sure how this works. Is it the array section which does the conversion, if so how does this work? Is there a sight explaining the parameters of such functions allot better than the ms help files? Thanks