Home 2017-11-22T06:37:21+00:00

How to Highlight Cells that are Less than a Value

Using conditional formatting, you can quickly highlight the numbers that are less than a value. Please follow the steps below: Step 1: Select the data cells or range; Step 2: Click "Home" from the Ribbon, then click "Conditional Formatting", select "Highlight Cells Rules"; Step 3: [...]

How to Highlight Cells that are Greater than a Value

Using conditional formatting, you can quickly highlight the numbers that are greater than a value. Please follow the steps below: Step 1: Select the data cells or range; Step 2: Click "Home" from the Ribbon, then click "Conditional Formatting", select "Highlight Cells Rules"; Step 3: [...]

What is the Number Custom Order

In "Format Cells" window, the custom order for numbers is positive number, negative number, zero and text. To have a try, please follow the steps below: Step 1: Select the data cells or range; Step 2: Right click to bring up the dialog box, from [...]

How to Use Phone Number Format

To turn numbers in the Phone Number format, please follow the steps below: Step 1: Select the data cells or range; Step 2: Right click to bring up the dialog box, from the list click "Format Cells"; Step 3: In the "Format Cells" window, click [...]

How to Change a number to Scientific Format

Scientific formatting is the way that making you easily handle very large numbers or very small numbers. Please follow the steps below: Step 1: Select the data cells or range; Step 2: Right click to bring up the dialog box, from the list click "Format [...]

How to Change the Fraction with no Integer

In Excel, fraction is commonly the mixed numbers: an integer and a proper fraction. To get rid of the integer part and turn it to part of the nominator, e.g., turn "2 1/5" into "11/5", please follow the steps below: Step 1: Select the cells [...]

How to Keep the Fraction Denominator Digits

Fraction in Excel is a bit tricky, when you enter fraction with one or two digits, the format automatically changed to the Date format, for example, when entering "11/21", the cell becomes "21-Nov". To properly enter the fraction, you will need to enter the integer [...]

How to Change the Numbers to Fraction

Change numbers to fraction, please follow the steps below: Step 1: Select the cells or range with numbers; Step 2: Right click to bring up the dialog box, from the list click "Format Cells"; Step 3: In the "Format Cells" window, click "Fraction" from the [...]




Recent Posts