Tags：format cells
-
How to Fully Display Long Numbers Over 11 Characters in Excel
Have you ever input long numbers in Excel and only to find the digits in the middle have been abbreviated? It’s actually because of scientific notation, which automatically abbreviates the number over 11 digits in length. So how could we fully display long numbers in Excel? One solution for this situation is converting the property […]
-
How to Use Format Cells to Quick Enter a Series of Data in Excel
When editing Excel spreadsheet, you can hardly avoid entering a series of similar data, like departments in company, product ID, e-mail address, etc. Some of them are almost the same, just a little difference in the begging or ending, but you still need to input them completely over and over, which is quite exhausting. In […]
-
How to Calculate the Time Difference Quickly Using Excel Functions
In practice, we often need to calculate the difference of years, months, weeks or days between 2 separate dates. And like many other calculations, Excel functions can help you calculate the time difference quickly and accurately. Let’s see how to do it. Case 1: Calculate the Difference of Years Formula: =DATEDIF(A2,B2,”y”) A2, B2 corresponds to […]
-
How to Display Numbers in Excel as Cell Phone Numbers
In Excel spreadsheet, the long numbers are often displayed in segments, which is not only easy to view, but also more standardized. So how to segment long numbers in Excel cells and make them displayed as cell phone numbers? You can solve this kind of problem simply by change the setting in Format Cells. 1. […]
-
How to Customize and Unify the Date Format in Excel Quickly
It’s quite troublesome to enter dates into Excel Spreadsheet with a canonical format manually. But if you don’t unify the format, it will affect the operation with formulas in the sheet. Therefore, I’d like to introduce 2 ways to unify the entered data and display them as the customized format. Method 1: Using Format Cells to […]
-
How to Batch Add Units to Cells in Excel Spreadsheet
Adding units to one or several cells in Excel might not be difficult and many people are likely to type them after the values directly. However, this approach is not just time-consuming, but can also affect the result for calculation and invalidate some formulas. So, how to add units to multiple cells in Excel exactly? […]
-
Tip to Quick Input Specified Text in Excel
If you want to type a great many repeated data in an Excel file like gender, department, etc. There’s a quick way in addition to add drop-down list. Let’s see the detailed steps. Assuming that I need type-in the gender of all employees in Excel. Should I input “Female” or “Male” in one after another […]
