The #NUM error occurs in your Excel spreadsheet when a function or formula contains invalid numeric values. Remove #NUM errors this way!

Microsoft Excel is a powerhouse when it comes to calculating numbers. With its vast assortment of functions, you can construct formulas to derive virtually any numeric result. However, if these ...

For the Remove Duplicates tool, even though 5 and 5.00 and $5 all have the same numerical value, they are still unique (not duplicate) values because they are formatted differently.

Excel typically removes the leading zeros before a number as you input the number in a cell. It treats cell entries lacking explicit formatting as numeric values by default.

How to Remove Duplicates That Are Case Sensitive in Excel 2007. By definition, Microsoft Excel 2007 considers a duplicate to be a row of data that matches another row in your worksheet exactly.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.