How to convert excel numbers into text
- 醉折花枝作酒筹Original
- 2021-05-19 11:30:2060427browse
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!
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
Previous article：How to add a column to a tableNext article：How to add a column to a table