How to convert excel numbers into text

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!