CHAPTER 3:
HancomMobileSheet
51
Number
#,##0;-#,##0
Displays a comma. "-" is displayed for negative
numbers
#,##0;[Red]-#,##0 Commas and negative numbers are displayed in red
#,##0.00;-#,##0.00
Displays a decimal point and a comma. "-" repre-
sents negative numbers
#,##0.00;[Red]-#,##0.00
Displays a decimal point and a comma. Negative
numbers are displayed using '-' are red
Accounting
_-* #,##0_-;-* #,##0_-;_-*
"-"_-;_-@* _-
ex) _-* #,##0_-;-* #,##0_-;_-* "-"_-;_-@* _-
The form of accounting is divided into four levels.
Positive Number(_-* #,##0_-) ; Negative Number(-*
#,##0_-) ; 0(_-* "-"_-) ; Character(_-@* _-).
Positive Number: _- leaves space for the number
of - and the width of - symbol, the number leaves
space for the number of _ and the width of -
symbol which will be put right after comma.
Negative Number: After marking as - symbol, the
number leaves space for the number of _ and the
width of - symbol which will be put right after
comma.
0: _- leaves space for the number of _ and the
width of - symbol, and 0 leaves space for the
number of _ and the width of - symbol after
marked as "-".
Character: _- leaves space for the number of _
and the width of - symbol, and after marking as
character, it leaves space for the number of _ and
the width of - symbol.
_-* #,##0.00_-;-*
#,##0.00_-;_-* "-"_-;_-@* _-
_-"$"* #,##0_-;-"$"*
#,##0_-;_-* "-"_-;_-@* _-
_-"$"* #,##0.00_-;-"$"*
#,##0.00_-;_-* "-"_-;_-@* _-
Currency "$"#,##0;-"$"#,##0 Monetary unit '$', displays a comma
"$"#,##0;[Red]-"$"#,##0
Monetary unit '$', comma and negative numbers
are displayed in red
"$"#,##0.00;-"$"#,##0.00
Monetary unit '$', A Comma, decimal point are
displayed. "-" is displayed for negative numbers
"$"#,##0.00;[Red]-"$"#,##0.00
Monetary unit '$', Comma, decimal point, negative
numbers are displayed in red
Percentage 0% % display
0.00% Displays a % and decimal point
Fraction # ?/?
Leave a space between the integer and fractions
and disignats a one figure digit for fractions
# ??/??
Leave a space between integers and fractions, and
designates two digits for fractions
Exponent 0.00E+00
Displays two digits above and under the decimal
point, and displays E+00 for the rest
##0.0E+0
Displays one digit above and under the decimal
point, and displays E+00 for the rest
To Next Page
Loading...
