The Excel table displays the operation method for both the day and the week

The Excel table displays the operation method for both the day and the week

Here is sample data.

The Excel table displays the operation method for both the day and the week

Select all data.

The Excel table displays the operation method for both the day and the week

Right-click the mouse and select [Format Cells].

The Excel table displays the operation method for both the day and the week

Next, a dialog box will pop up to format the cells, click [Customize] in the left list.

The Excel table displays the operation method for both the day and the week

Then add four AAAA after Type.

The Excel table displays the operation method for both the day and the week

After clicking OK, the day of the week will be automatically displayed after the time.

The Excel table displays the operation method for both the day and the week

This article is reprinted in: https://xiazai.zol.com.cn/jiqiao/118780.html If there is any infringement, please contact admin@zhengruan.com delete

评论已关闭。