Here is sample data.
Select all data.
Right-click the mouse and select [Format Cells].
Next, a dialog box will pop up to format the cells, click [Customize] in the left list.
Then add four AAAA after Type.
After clicking OK, the day of the week will be automatically displayed after the time.
This article is reprinted in: https://xiazai.zol.com.cn/jiqiao/118780.html If there is any infringement, please contact admin@zhengruan.com delete