Advanced of Choosing the Number Format

In addition through the tools in the Group Number, you can format the numbers by pressing Ctrl + 1 so that the Cell Format dialog box appears. Then select the Number tab.


Formatting Numbers By Custom
There is a numeric format in Excel custom options. In this category provided a choice of diverse format that is expected to meet the needs of the wearer. However, in addition to formatting options that you have available, you can also design their own form of the display format numbers according to the needs and your creations.

Format	Data typed	Positive values are displayed
General	125	125.00
0	125	125
0.00	125.00	125.00
#,##0	1257	1,257
#,##0.00	1257	1,257.00
#,##0_);(#,##O)	1257	1,257
#,##0_);[Red](#,##O)	1257	1,257
#,##0.00_);(#,##O.OO)	1257.126	1,257.13
#,##0.00_);[Red](#,##O.OO)	1257.126	1,257.13
$#,##0_);($#,##0)	1257.126	$1,257
$#,##0_);[Red]($#,##0)	1257.126	$1,257
$#,##0.00_);($#,##0.00)	1257.126	$1,257.13
$#,##0.00_);[Red]($#,##0.00)	1257.126	$1,257.13
0%	0.25	25%
0.00%	0.2575	25.75%
O.OOE+OO	1257.126	1.26E+03
##O.OE+O	1257.126	1.3E+3
#?/?	1257.126	1257 118
# ??/??	1257.0126	1257 1/79
m/d/yy	20jul	7/20/97
d-mmm-yy	20jul97	20-Jul-97
d-mmm	20jul97	20-Jul
mmm-yy	20jul97	Jul-97
h:mmAM/PM	11:31	11:31 AM
h:mm:ss AM/PM	11:31	11:31:00 AM
h:mm	11:31	1:31
h:mm:ss	11:31	11:31:00
m/d/yy h:mm	20jul97	7/20/97 0:00
mm:ss	11:31:45	31:45
mm:ss,O	11:31:45	11:31:45
@	20 jul 97	35631
[h]:mm:ss	11:31:45	11:31:45
_($* #,##O_);_($* (#,##0);_($"-"_);(@_)	10035.75	$ 10,036
_(* #,##O_);_(* (#,##0);_(*"-"_);(@_)	10035.75	10,036
_($* #,##0.00 );_($* (#,##0.00);_($"-"?? );(@_)	10035.75	$ 10,035.75
_(* #,##0.00 );_(* (#,##0.00);_(*"-"?? );(@_)	10035.75	10,035.75

Writing Custom Numeric Format consists of four parts as in the following example.
positive number format; format negative numbers; the format of writing the number zero; text format
• The first position format to write the number with a positive value.
• The second position states the format of writing numbers with a negative value.
• The third position to state how the format to write a value of zero.
• The fourth position turns writing format hila its entry in text format.
Each section separated sign a semi colon (semicolon).