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.

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

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

You can subtract in Excel by placing a minus sign in front of any numbers you want to deduct. You can add and subtract a bunch of numbers at once using the equal sign or SUM function. You can add and ...

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...

A Social Security number consists of three strings of digits separated by hyphens. Historically, the first was an area number, which relates to the resident's geographic location; the second was a ...

Random number generation is an essential feature in Excel, allowing users to perform tasks such as simulations, creating test datasets, or experimenting with spreadsheet models. Excel provides ...

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

You may want to multiply cells or numbers in Microsoft Excel to analyze data. Here's what you need to know to do it.