Number formatting can be applied to a single cell, entire columns or rows, a select range of cells, or an entire worksheet. There are several ways to change number formatting: Number formatting does not change the actual number in the cell, just the way it appears.įor example, select a cell that has been formatted for negative, special, or long numbers and the plain number rather than the formatted number displays in the formula bar above the worksheet. Number formatting is attached to the cell and not to the value in the cell. Number formatting in Excel changes the appearance of a number or value in a cell in the worksheet.
