Group Number

This group provides a number of formatting tools quickly. Being if necessary formatting specifically click the arrow button    in the lower right corner of this group to display the Cell Format dialog box, Tab Number.

 Excel has a lot of numeric formats including the writing of the date and time format. In addition to the default formats are ready for use, you will still be able to define its own format to suit your needs. The additional format is known as custom formats.

In the top selection box is provided formats are generally the most commonly used. If we click on the small button  the right of the box will display the names of numeric format.
While the formats are numerically more as follows.

General Format
Display figures without specific format. If the integer numbers written exceeds Iebar column, Excel will automatically change in exponent form. .1257 Typed will be displayed 0.1257, and 345.0 will be displayed 345 only.

Number Format
Writing numbers by taking into account the positive or negative value. Positive values shown no sign +, but it has a negative value of 4 kinds of writing format.


Currency
Writing numbers as the value of the currency. Currency symbols adapted to regional format is selected via the Control Panel, Regional Settings. Regional choice English (United Stated) will display the symbol $, while the regional selection Indonesian Rp will display. Writing currency symbols attached on the left of the first digit number without spaces separated.


Accounting Format
Displays the value of the currency with the currency symbol the left and the right with the average number is the thousands separator and two decimal digits. This format also offers the desired number of decimal digits.


Date Format
To display an assortment of writing the date.


Time Format
To show various forms of writing / time value.


Percentage Format
Displays percentage (1/100) complete with sign% behind the figures, along with defining the number of digits in a decimal value.

Fraction Format
Displaying the form of writing a float value.

Scientific Format
Form numbers exponentially.


Text Format
Display figures are converted as text so it is not worth.

Special Format
Forms special numbers such as postal area code number, phone number, social security number that is valid in the USA.

Custom Format
The forms display numbers that you define yourself. Form a very wide choice and you can modify yourself.

Displaying and Hiding Decimal
At Group Number there are two tools that serves to show and hide single-digit decimal number by one digit
Increase Decimal     Decrease Decimal

Excel provides a fast typist for the ease with some shortcut buttons for formatting numbers with a particular format as follows:

Format	Tombol Shortcut
General	Shift+Ctrl+ -
Number (2 decimal places)	Shift+Ctrl+ !
Currency (2 decimal places)	Shift+Ctrl+ $
Percent (without decimal)	Shift+Ctrl+ %
Scientific	Shift+Ctrl+ "