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.
文章識別碼：4028682 - 最後檢閱時間：2017年8月1日 - 修訂： 1