The process of setting data format in excel: After selecting data in EXCEL, you can set the data format in Excel table in the cell format option. Please refer to the following steps for specific operations.

1. Open the target excel file on the computer and find the table area where the data is located in the editing area.

2. Then use the mouse box to select the EXCEL table area to format the data.

3. Then click the right mouse button, find the "cell format" option in the right-click menu and click it.

4. After entering the "Cell Format" dialog box, select the data format according to your personal needs on the number options page, and then click OK to exit.

5. After completing the above settings, you can find that the data format has become the required format.