For some data types, such as a date or a percentage, Excel will change a cell's number format automatically as soon as you type it into a cell. Otherwise, there are various ways to change a number ...