'mm/dd/yyyy to be changed to dd/mm/yyyy using VBA

[agasi]

How can I convert 'mm/dd/yyyy to a date format in dd/mm/yyyy using vba?

ex: '11/23/2016 to 23/11/2016

 

[chicagocomputerclasses]

assuming that you have your system dates in format dd/mm/yyyy
this should work

Range("A1").TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo :=Array(1, 3), TrailingMinusNumbers:=True

 

[agasi]

Thank you. It works! Really appreciated it.