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

Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

How to Separate Text From Numbers in Excel. When you open a raw data file in Excel, the program doesn't always recognize the way in which the data is formatted, such as comma-delimited, tab ...

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

Microsoft Excel: How to Find Missing Numbers in a Sequence. Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate ...

Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...

Learn how to generate random numbers in Excel using RAND, RANDBETWEEN, and RANDARRAY. Step-by-step guide with practical tips included ...

Microsoft Excel has hundreds of built-in functions, but even those don't cover every need. Here's how to use LAMBDA to easily create custom functions.