How do i show only a number greater than 10 in Excel?

Today we are going to learn a little Excel trick, in Excel set only shows the number of heavy rain 10, you know how to operate the code? If you don't understand it, just come and learn how to operate.

How do i show only a number greater than 10 in Excel?

As the following illustration shows, column B is a number, a mixed-letter content. Requirements show only numbers greater than 10, others are hidden.

Operation Steps:

Select Area-CTRL + Number 1 open Cell Settings window-number-custom-Enter custom code in the right text box: [>10]g/General format;

Note: All red should be entered, including the final English status quotes (;)

The effect of setting the finish is shown in the following illustration.

So the number greater than 10 is hidden.