Formatting your numbers changes the appearance of the data in your worksheet, but doesn't change its value. The formatted number is displayed in the cell, and the actual value is displayed in the formula bar. Excel provides several numeric formats for you to use in your workbook, including currency, percentage, date, time, and accounting.
To format numbers: