How Excel worksheet number formats are set

Source: Internet
Author: User

By applying a different number format, you can display the number as a percentage, date, currency, and so on. For example, if you are working on a quarterly budget, you can use the currency number format to display currency values. The operation is as follows:

1, select the cells you want to format, on the Start tab, in the Number group, click the dialog Box Launcher next to Number (or right click and select Format Cells) to bring up the Format Cells dialog box.

2, in the Format Cells dialog box, in the Categories list, click the format that you want to use, and adjust the settings if necessary. For example, if you are using the currency format, you can select a different currency symbol, display more or fewer decimal places, or change the way negative numbers are displayed.


After you apply a number format to a cell, if Excel displays ##### in the cell, the cell may not be wide enough to display the data. To extend the column width, double-click the #错误的单元格的列的右边界 that contains the occurrence. This automatically adjusts the size of the column so that it fits the number. You can also drag the right boundary until the column reaches the desired size.

In most cases, whether you enter numbers in a worksheet or import numbers from a database or other external source, the numbers are displayed the way you want them to be. However, Excel occasionally applies the wrong number format, so you may need to make some adjustments. For example, if you type a number that contains a slash mark (/) or hyphen (-), Excel might interpret it as a date and convert it to date format. If you want to type a value that is not calculated (such as 10e5, 1 p, or 1-2), but you do not want Excel to convert the value to a built-in number format, you can apply the text format to the cell, and then enter a number.

If the built-in number format does not meet your needs, you can also create your own custom number format. Because the code used to create a digital format is difficult to understand quickly, it is a good idea to use one of the built-in number formats before you change any of the code sections in that format to create your own custom number format. To see the number format code for a built-in number format, click the Custom category, and then view the Type box. For example, using the code [<=9999999]###-####;(###) ###-#### can display the phone number (555) 555-1234.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.