2] Using custom formatting You can create your own custom format in Excel to highlight negative numbers. Select the range of cells containing the numbers. On the Home tab in the Numbers group ...

Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.

Padding Numbers In the previous example you saw that we can format numbers and force then to display a fixed number of decimal places. The 0.00 part of the custom format makes this happen. For example ...

However, Excel's random number functions are volatile, meaning they change constantly. In this article, I'll show you how to generate and fix random numbers and remove duplicates.

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.

Want to know how to create a scatter plot in Excel? Here's a guide on how we created a simple chart based on performance numbers.

Microsoft Excel inherently offers a numbering system to automatically create a series of incremented numbers. Enter any starting value in cell A1. Enter the next value in cell A2 to establish a ...

Excel can do more than just render typed numbers in tables of cells. It can take two columns of numbers and show a pictorial representation of how they relate to each other through a graph.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.