Home > Topics > excel > How to implement date slash in excel table

How to implement date slash in excel table

藏色散人
Release: 2019-06-10 11:48:30
Original
30682 people have browsed it

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 implement date slash in excel table

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.

How to implement date slash in excel table

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.

How to implement date slash in excel table

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

How to implement date slash in excel table

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

How to implement date slash in excel table

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

How to implement date slash in excel table

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

How to implement date slash in excel table

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template