how to change mm/dd/yyyy to dd/mm/yyyy

[baskar5353]

Hi,

how to change format mm/dd/yyyy to dd/mm/yyyy in VBA.

 

[RCBricker]

format(cell,"dd/mm/yyyy")

 

[Macropod]

Dim StrDt As String
StrDt = InputBox("Input the mm/dd/yyyy date to convert", , "mm/dd/yyyy")
MsgBox StrDt & " to " & Format(Split(StrDt, "/")(1), "00") & "/" & Format(Split(StrDt, "/")(0), "00") & "/" & Format(Split(StrDt, "/")(2), "0000")

 

[baskar5353]

It not updating in sheet. but formula bar it showing as dd/mm/yyyy format. in cells it showing as mm/dd/yyyy only not updating

 

[baskar5353]

it not change get change in cells

 

[baskar5353]

it showing as 25/12/2014 only

 

[Joe4]

If you just want to change the cell format, use something like:

Columns("A:A").NumberFormat = "dd/mm/yyyy"

Note your entries have to be date entries and not text entries in order for this to work!