How to set the number format in excel cells

How to set the excel cell number format: first select the number format on the "Set Cell Format" page; then select the decimal place of "Number" in the "Number" group; then select the currency symbol for the currency; finally Select "Text" in the "Number" group to display it in text mode.

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

How to set the number format in excel cells:

1. Select the number format on the "Set Cell Format" page.

#2. In the "Number" group, select the decimal place of the "Value".

3. For currency, you can choose the currency symbol.

4. Or select "Accounting Only" to use accounting mode Display numbers.

5, or select "Date" to display it as a date.

6. Select "Text" in the "Number" group to display it in text mode.

Related learning recommendations: excel tutorial

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