How to add a "+" sign before a positive number in an Excel table

Source: Internet
Author: User

By default, the minus sign "-" appears before a negative number in an Excel worksheet, and a positive number does not show a plus +. What if we not only need to display the minus sign before the negative numbers in the Excel table, but also the positive signs before the positives?

1. Start Excel2007, open the workbook file you want, and then, on the worksheet you want, select the range of cells that you want to show the plus sign.

2. Click the Start tab, and then in the number group, click the dialog Box Launcher (Figure 1).

Figure 1 Dialog Box Launcher

3. Click the Number tab, and then in the Category box, click Custom, and in the box under Type, type +0;-0;0;@ (Figure 2). Note that you are typing half-width characters, preferably in the English state. Finally, click the OK button.

Figure 2 Custom Styles

You will now automatically add a plus sign "+" before the positive numbers that are already in the area, and then you will automatically add "+" before the positive number when you enter a positive number.

Excel allows users to define positive, negative, 0 values, and text display formats at the same time, separated by a half-width semicolon ";" Interval. For example, in "+0;-0;0;" In this custom format, the "+0" before the 1th semicolon is the display format that defines a positive number. The "0" before the 2nd semicolon is the display format for defining negative numbers; the "0" before the 3rd semicolon is the display format that defines 0 values; the "@" after the 3rd semicolon is the display format for defining the text, which is the normal display of the text. If a location between three semicolons does not type any characters, the type of data is hidden, such as the format "0;-0;; @ "Hides the 0 value in the cell.

Knowing these, you can use this ";" To accomplish a special task, such as hiding all the data (including text) from the entire worksheet, define all the cells in the entire worksheet as ";;;" Format can be.

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.