Excel 2013
You can automate a repetitive task in Microsoft Excel by recording a macro.
Imagine you have dates in random formats. You can apply a single format to all of them using a macro. Record a macro applying the format you want, and then replay the macro whenever needed.
Watch a demo to create a macro that formats dates in Excel.
Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable the Developer tab in Excel.
Excel 2016
You can automate a repetitive task in Microsoft Excel by recording a macro.
Imagine you have dates in random formats. You can apply a single format to all of them using a macro. Record a macro applying the format you want, and then replay the macro whenever needed.
Watch a demo to create a macro that formats dates in Excel .
Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable the Developer tab in Excel.
