How to change US date format to UK date format - dd/mm/yyyy

[vbanewbie68]

Hi

Please could you show me how to change from US date to United Kingdom Date like this dd/mm/yyyy?

Thank you in advance

Best regards

V

Sub Add_Rows_Data()
LastRow = Imprt.Cells(1, 1).End(xlDown).Row
DatePaymentMade = WorksheetFunction.Match("DatePaymentMade", Imprt.Cells(1, 1).EntireRow, 0)
For x = 2 To LastRow

Imprt.Cells(x, DatePaymentMade).Value = DateValue(Cells(x, DatePaymentMade).Text) 'Date format

Next x

End Sub

 

[Dave Patton]

Sub FixDate6()
' USA text DateTime retain just Date Value
' Custom format the date dd-mmm-yyyy

  With Selection
    .TextToColumns DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=1, Tab:=0, _
        Semicolon:=0, Comma:=0, Space:=1, Other:=0, FieldInfo:=Array(Array(1, 3), Array(2, 9), Array(3, 9)), TrailingMinusNumbers:=1
     .NumberFormat = "dd-mmm-yyyy"
  End With
End Sub

 

[vbanewbie68]

"Thanks for this and got the date correct but can't rid of the time stamp."

Time does not show on your post.
Do you require an edit to the code to ignore the time?

Hello!
I saw an alert message from you and when I login this and there is no message from you. Did you send a reply?

Warm regards

V

 

[Fluff]

Did you send a reply?

Yes it's post#11, which is the first post on page 2 of this thread, so you may have missed it.

 

[vbanewbie68]

Yes it's post#11, which is the first post on page 2 of this thread, so you may have missed it.

Brilliant. It works! Thanks for this and your time which is greatly appreciated!

 

[Dave Patton]

Thanks for the feedback.