Home  >  Article  >  Topics  >  How to convert excel numbers into text

How to convert excel numbers into text

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-19 11:30:2060374browse

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

How to convert excel numbers into text

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.

How to convert excel numbers into text

Click "Format Cells" and click "Customize".

How to convert excel numbers into text

Enter "[dbnum2]0000年00月00日" and click "OK".

How to convert excel numbers into text

How to convert excel numbers into text

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!

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