Conversion method: First select the specified cell; then click the "Start" - "Cells" option at the top of the page, select "Format Cells" in the drop-down list; then click "Customize", in Enter "[dbnum2]0000年00月00日" in the "Type" input box; finally click "OK".
The operating environment of this tutorial: windows7 system, WPS Office2019 version, Dell G3 computer.
Take date conversion as an example, select the cells that need to be converted.
Click "Format Cells" and click "Customize".
Enter "[dbnum2]0000年00月00日" and click "OK".
Related learning recommendations: excel tutorial
The above is the detailed content of How to convert excel numbers into text. For more information, please follow other related articles on the PHP Chinese website!