Home  >  Article  >  Topics  >  How to change the excel table date into a regular numerical value?

How to change the excel table date into a regular numerical value?

coldplay.xixi
coldplay.xixiOriginal
2020-07-27 13:52:3416954browse

The solution to convert the excel table date into a regular value: first click to open the [Start] tab; then click the drop-down menu next to [General]; and finally click the short date or long date in the pop-up menu.

How to change the excel table date into a regular numerical value?

Solution to convert excel table date into a regular value:

1. Click to open the "Start" tab .

How to change the excel table date into a regular numerical value?

2. From the number format option on the "Home" tab, you can see that the number format of the selected cell is "General". If you want to change it to date format, first click the small triangle of the number format option in the "Home" tab as shown in the picture.

How to change the excel table date into a regular numerical value?

#3. Click the short date or long date in the pop-up menu.

How to change the excel table date into a regular numerical value?

#4. After clicking the short date, the date format is as shown in the figure.

How to change the excel table date into a regular numerical value?

#5. After clicking on the long date, the date format will be as shown in the figure.

How to change the excel table date into a regular numerical value?

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to change the excel table date into a regular numerical value?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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