Excel macro

[Nishant]

can somebody help me in writing a macro that changes the date format in
a specified selection of cells. I want date to be changed from YYYYMMDD
to MM/DD/YYYY format and paste special on the same cells.

[Niek Otten]

Sub Macro1()
Selection.NumberFormat = "mm/dd/yyyy"
End Sub

--
Kind regards,

Niek Otten

"Nishant" <[email protected]> wrote in message
news:[email protected]...
> can somebody help me in writing a macro that changes the date format in
> a specified selection of cells. I want date to be changed from YYYYMMDD
> to MM/DD/YYYY format and paste special on the same cells.
>