Change date Format

[Foncesa]

Hi,

I import file wherein the column A date is stored 22/05/2017 want Column A date to be format like 22-05-2017 with macro.

Thanks.

[mana]

you can use macro recorder.

[mdmackillop]

Sub DateFormat()
Columns(1).NumberFormat = "dd-mm-yyyy"
End Sub

[Foncesa]

Hi,

Thanks mdmackillop (http://www.vbaexpress.com/forum/member.php?87-mdmackillop) for the reply, but its not working in my case, i have attached the sample file please have a look.

Thanks.

[mdmackillop]

Try

Sub DateFormat()
Columns(1).NumberFormat = "dd-mm-yyyy"
Columns(1).Value = Columns(1).Value
End Sub