How to format data in excel

How to format excelData

1. Open excel on the computer and need Demonstration document, then select the "Student Number Column", right-click the "Format Cells" option, in the number options, select the "Text" option, click the "OK" option;

2. Then select all the results with the mouse, right-click the "Format Cells" option, find the "Value" option in the final category, and click the "Value" option;

3. Find the numerical option in the new pop-up box. After clicking the numerical option, select 2 decimal points on the page, and then click OK.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to format data in excel. For more information, please follow other related articles on the PHP Chinese website!