When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...

Product IDs, serial numbers and other reference numbers require a unique identifier to avoid confusion when referencing a product or specific data point. Although you can manually enter unique numbers ...

There are a few common techniques for performing division in Excel. You can divide numbers directly in a single cell, or use a simple formula to divide the contents of two different cells. You can ...

Trying to use an Excel Date and Time function, but Excel returns a serial number instead of date; this is because Excel stores dates and times in serial numbers in the backend; for instance, when you ...

A custom AutoFill series is a list of values you enter frequently. This list might consist of employee names, department names, and so on. The problem is that you enter them over and over. You can ...