Home >Topics >excel >How to convert excel time format

How to convert excel time format

angryTom
angryTomOriginal
2019-07-25 11:54:1435762browse

How to convert excel time format

If you want to learn more about Excel operations, you can click: Excel Tutorial

##We often enter various dates in Excel, but sometimes in order to save time, we may not enter it in a formal way. At this time, we can set the automatic date format conversion function in Excel to easily convert it to what we want. format. This tutorial will explain in detail some common methods of input date conversion in Excel!

Date format conversion format 1: When entering 20120920, it will be automatically converted to 2012-09-20

First open the Excel table and select the need to convert cell, then right-click the mouse and select [Format Cells] in the pop-up list. As shown in the picture:

How to convert excel time format

In the pop-up window, click the [Number] button above, select the [Custom] option in the list, and then enter it in the type input box [0000-00-00] format, click OK. As shown in the picture:

How to convert excel time format

#Display format, let’s take a look at the format we just set, select the cell we just set, enter 20120920, and press Enter. As shown in the figure:

How to convert excel time format

##Date format conversion format 2: When entering 20120920, it will be automatically converted to September 20, 2012The steps are similar to the above, but enter the format of [

#年##月##日] in the type input box, and then confirm. As shown in the picture:

How to convert excel time format

#Display format, enter 20120920 in the cell we just set, and then press Enter. As shown in the figure:

How to convert excel time format

##Date format conversion format three: When 20120920 is entered, it will be automatically converted to 201209920 The steps are similar to the above, but enter the format [[dbnum2]0000年00月00日] in the type input box, and then confirm. As shown in the picture:

How to convert excel time format#Display format, enter 20120920 in the cell we just set, and then press Enter. as the picture shows:

The above is the detailed content of How to convert excel time format. 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