Ways to hide text in Excel

Source: Internet
Author: User

In Excel, you will often find that you cannot enter a single 0 value, but it is hidden, except for 0 that we can hide the various characters.

0 value hidden know it, in the "tool" "Options" "View" "0 value", the previous check can be canceled. But what if the hidden value is specified? for example, greater than 15, or less than 100, or text this with the IF function of course can be solved, there are some other functions can be done, but the operation of pure techniques how to do? Conditional formatting is one way to do this: customize cells.

Operation Steps

1, choose "Cell" "format" "Number" "" Custom "

Computer Tutorials

Seems to be a bunch of things look dizzy, but as long as clear the law, everything ok~

2, in fact, just three semicolons in the mischief, the cell divided into positive digits; negative digits; 0 bits; text bit:

Of course, these four bits can also be enforced according to our own needs, as shown in the example above.

In addition, the code is the second parameter of the text function.

Can try: =text (A1, "[>100]0;;;")

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.