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

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.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Change "x" and "y" to the minimum and maximum values of your random number. The INT function will simply remove all the numbers after the decimal point, leaving you with just the integer.