Excel FormattingLesson 26Free preview

Excel Format Numbers

This lesson is part of Excel · All levels

Summary

The numeric format determines how values are displayed: Numbers with decimals, Currency with money symbols, Percentage, Date, and so on. The important thing is, the format just changes the look, the original value remains so that the formula calculation is unaffected. The Decimal Increase/Decrease button on the Number group accelerates the adjustment of the decimal number.

Key points

Main format: General, Number, Currency, Accounting, Percentage, Date
0.25 with the Percentage format appears as 25%
Currency puts the symbols of money close to the numbers, accounting arranges them neatly on the edges of the cell
The format does not change the original value of the formula

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.