You can display a table cell by formatting it as text. The specific operation steps are as follows:
1. Create a blank EXCEL worksheet, and then open it.
2. When some big data with more than 12 bits is input, the default cell value is displayed in E+ state.
3. Select the input first, then click the right mouse button anywhere to display the property tab, and find the cell format option in the property tab.
4. Click the cell format option and a format dialog box will pop up. Locate the customization in the dialog box and click.
5. After clicking Customize, we will enter 0 in the format of the pop-up window to indicate a mandatory placeholder, and then confirm.
6. After confirmation, you can see that all the data are displayed according to the actual situation.