Home > Topics > excel > What should I do if the table number finally becomes 0?

What should I do if the table number finally becomes 0?

angryTom
Release: 2019-07-26 15:01:22
Original
28696 people have browsed it

What should I do if the table number finally becomes 0?

Recommended tutorial: Excel tutorial

Excel can enter 15 digits by default , if it exceeds this length, the last few digits in scientific notation will be changed to 0. Here I will introduce how to set up to avoid this situation

1. Open excel and select the data that needs to be edited

What should I do if the table number finally becomes 0?

2. Select the "Start" function

What should I do if the table number finally becomes 0?

3. Find the number function and click the small triangle in the lower right corner

What should I do if the table number finally becomes 0?

4. Select "Number" in the pop-up dialog box

What should I do if the table number finally becomes 0?

5. Select the "Text" function

What should I do if the table number finally becomes 0?

#6. Click "OK"

What should I do if the table number finally becomes 0?

#7. At this time, set the cell to text format and you can enter any data

What should I do if the table number finally becomes 0?

The above is the detailed content of What should I do if the table number finally becomes 0?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template