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.
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.
Article ID: 4028682 - Last Review: 1.8.2017 - Revision: 1