Excel macro
 

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.

Excel macro
 

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

--
Kind regards,

Niek Otten

"Nishant" wrote in message
ups.com...
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.