How to use text function to convert date format in excel

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".

##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")

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

Enter the following formula to achieve:

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

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!