Basic method to convert Excel horizontal date date into slash

Dear readers, have you ever encountered the problem that the horizontal bar date in Excel cannot be parsed normally, causing inconvenience in data processing and analysis? PHP editor Banana brings you the basic method of converting Excel horizontal dates into slashes, and will provide you with a step-by-step guide to solve this common problem. By reading this article, you will learn a simple method to seamlessly convert dash dates to slash dates, ensuring data consistency and accuracy.

First determine the format of the date. There are generally two types, date format and text format. The two formats have different modification methods:

If it is a date format, select the date In this column, press CTLR 1 to bring up the cell format, directly select the slash format in the date, and click OK.

If this column is in text format, after selecting it, click [Data] - [Column] above, click Next twice in the window, in the last step, in Select [Date] in the column data format, and the horizontal bar will become a slash.

The above is the detailed content of Basic method to convert Excel horizontal date date into slash. For more information, please follow other related articles on the PHP Chinese website!