Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to. In this article, I'll explain what each number format ...

To show numbers in thousands or millions in Excel, you can use these two formatting conditions: #0,”K” and #0,,”M”. To apply them, select the cell, right-click on it, and select the Format ...

The solution is to use a custom format to reinstate the zeros. So, if you have five digit product numbers, select the cells containing the product numbers, choose Format > Cells > Number tab, and ...

Open the Excel 2010 file that contains the phone numbers you want to change. Click on the cell that contains the phone number, or click on the range of cells if you want to change the format for ...

C3 is empty, so there’s nothing for Excel to do yet, but we know that if the input value is 10 numeric digits, that the format will display the value as expected. The next step is to add data ...

To stop this automatic simplification, you need to tell Excel what denominator to use. In other words, to keep "4/6" as is, ...

Microsoft Office Excel can be configured to display a number with the default currency symbol. In addition to the options for currency symbols, the format has options for the number of decimal ...

Excel offers several built-in conditional formatting rules you can apply to your data. (Click image to enlarge it.) We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.

If you change the format of empty cells, any numbers you type in those cells are converted to percentages automatically. Launch Excel and open the workbook that contains the spreadsheet you want ...

Excel is known for automatically formatting certain entries, which is often useful but sometimes annoying. This automatic function can now be deactivated on an individual level. We'll show you how.