| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
| Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming | |||
Hybrid Mode
