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. If ...

Lists of phone numbers are very common with Microsoft Excel editors. In the case of landline and foreign phone numbers, adding the country code is important, or the caller will never be able to dial ...

Data validation in Excel lets you restrict what can be entered into a cell, whether whole numbers, decimals, dates, or a certain number of characters. However, one of the most powerful capabilities of ...

Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border. They can also change the text's color. For example, ...

I began writing this series of blogs on Excel for Microcontroller Central. When it was shut down, Brad Albing (then editor of Planet Analog) agreed to copy the existing database across as a base for ...