Home  >  Article  >  How to set the number format in excel cells

How to set the number format in excel cells

coldplay.xixi
coldplay.xixiOriginal
2021-01-07 14:43:3187217browse

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.

How to set the number format in excel cells

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.

How to set the number format in excel cells

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

How to set the number format in excel cells

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

How to set the number format in excel cells

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

How to set the number format in excel cells

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

How to set the number format in excel cells

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

How to set the number format in excel cells

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn