Home>Article>Topics> How to use text function to convert date format in excel

How to use text function to convert date format in excel

青灯夜游
青灯夜游 Original
2021-04-19 16:12:41 57937browse

Conversion method: 1. Use the "TEXT(specified cell, "yyyy-mm-dd")" statement to modify the date format to "yyyy-mm-dd"; 2. Use "TEXT((specified cell Format, "yyyy year mm month dd day")" statement changes the date format to "yyyy year mm month dd day".

How to use text function to convert date format in excel

##The operating environment of this tutorial: windows7 System, Microsoft Office Excel 2016 version, Dell G3 computer.

1. Modify the date format to yyyy-mm-dd

Enter the following formula to achieve:

=TEXT(A2,"yyyy-mm-dd")

How to use text function to convert date format in excel

2. Modify the date format to yyyy year mm month dd day

Enter the following formula to achieve:

=TEXT(A2,"yyyy年mm月dd日")

How to use text function to convert date format in excel

Related learning recommendations:

excel tutorial

The above is the detailed content of How to use text function to convert date format in excel. 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