What do you do with an Excel parenthesis as a minus sign?

Source: Internet
Author: User

Excel is often used in our daily computer software, if you learn Excel can be to a certain extent greatly improve the efficiency of the work. We are in the process of using Excel will encounter various problems, such as the input (), will become-this situation, then how to deal with it?

1, as shown in the picture, we in any one of the Excel cell input (18) such words, and then we press ENTER, when the original display of "(18)" Cell suddenly become "-18", which is what we say.

2, this situation is mainly because in the regular input, Excel () is exactly the same as, it will cause this situation, when we look at the cell format, will be displayed as "-18" style

3, then we have to do is to delete the contents of the original cell, it can be changed into a text format, we first set the cell format to text, and then enter (18), carriage return, found that the display or "(18)"

4, or we can use the shortcut, in the cell input "' (18)", input before adding a ' symbol, it means that the cell format into the text format, to achieve the same effect as above

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: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.