You can change the appearance of the data in the cells of a worksheet without changing the actual value in the cell. You can apply numeric formats to numbers to better reflect the type of information they represent—dollars, dates, decimals, and so on. For example, you can format a number to display up to 15 decimal places or none at all. If you don’t see the number format you need, you can create a custom one.
Format Numbers Quickly
Select a cell or range that contains the number(s) you want to format.