What should I do if the numbers change after excel is divided into columns?

The number changes after excel is sorted is because the data after sorting is too long, causing it to be displayed in scientific notation in new cells. The solution: first enter the dialog box of the sort wizard and select "Fixed width" option; then click on a column with data; finally select the "Text" option and click the "Finish" button.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer

What happens to the numbers after excel is sorted? manage?

Cause: The data after column classification is too long, causing it to be displayed in scientific notation in new cells.

Solution:

First enter a set of data that needs to be separated into columns in the open excel table.

Then click "Data" in the toolbar and select the "Column" option.

You can select the "Fixed Width" option when entering the dialog box of the Column Wizard.

Then on the wizard page of the second step, point the arrow to the position where you want to divide the columns, and click Next.

Then click on the list with data in the third step of settings, select the "Text" option, and click the "Finish" button.

#The data can be sorted out in text format, and the data content will not change.

Recommended study: "Excel Tutorial"

The above is the detailed content of What should I do if the numbers change after excel is divided into columns?. For more information, please follow other related articles on the PHP Chinese website!