Change date format

[Fiske]

hi guys
how do i change the date format to d/mmm/yyyy
rather then d/mm/yyyy

Cells(x, "E").Value = Date & " "
Cells(x, "E").NumberFormat = "d/mmm/yyyy"

Thanks!

 

[steve the fish]

Hi remove the & " " from the first line. This is preventing excel from seeing it as a date.

 

[Fiske]

Hi Steve! thanks for the reply, i removed it and now it shows 42174

 

[steve the fish]

Ok switch the lines so the formatting of the cell is done first before the date is added. Or you could just say:

Cells(x, "E").Value = Format(Date, "d/mmm/yyyy")

 

[Fiske]

It works!
Thanks steve! Much appreciated! ^^