How to implement date slash in excel table

When we edit the Excel table, we see that the date has changed into a horizontal box style. How to convert all of it into slashes? Let’s take a look at how to operate it.

How to batch change dates in Excel2016 table from horizontal bars to slashes

How to implement date slashes in Excel table:

Let’s first take a look at the currently entered date format. The entered dates are all changed into horizontal dashes.

At this time we can select all the cells to be converted, then right-click the cell and select the "Format Cells" menu item in the pop-up menu.

The window for setting cell format will open next. In the window, we click the "Customize" menu item in the left sidebar.

Next in the right window, we find the type edit box

Enter yyyy in the edit box /m/d, then the above example will show the preview effect after conversion

After pressing the confirm button, you can see that all current dates have become oblique The bar style.

For more technical articles on the use of Excel, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to implement date slash in excel table. For more information, please follow other related articles on the PHP Chinese website!