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.
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.
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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks