If you're using Excel to calculate monetary values, then you only have to worry about two decimal places in your numbers. Aligning your numbers to the right automatically lines up the decimal points ...

Excel displays the original number up to 11 digits. When you enter a number that has more than 11 digits, Excel does not display the original value. Instead, it displays the number in the exponential ...

One of the most common requests I receive from users is how to identify duplicate and unique values in Microsoft Excel. The easiest way I know is to apply a conditional format. In a nutshell, a ...

When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in-depth examination of specific sales results, ...

The article, How to highlight unique values in Excel, shows two easy ways to apply conditional formatting to unique values or the row that contains a unique value. In this article, we’ll do the same ...