Пішім сипаты - Сан және валюта дерек түрлері

Маңызды :  This article is machine translated, see the disclaimer. Please find the English version of this article here for your reference.

You can set the Format property to predefined number formats or custom number formats for the Number and Currency data types.

Параметр

Predefined Formats

The following table shows the predefined Format property settings for numbers.

Параметр

Сипаттама

"General Number"

(Default) Display the number as entered.

Валюта

Use the thousand бөлгіш; follow the settings specified in the regional settings of Windows for negative amounts, decimal and currency symbols, and decimal places.

евро

Use the euro symbol ( Eвро ), regardless of the currency symbol specified in the regional settings of Windows.

"Fixed"

Display at least one digit; follow the settings specified in the regional settings of Windows for negative amounts, decimal and currency symbols, and decimal places.

Стандартты

Use the thousand separator; follow the settings specified in the regional settings of Windows for negative amounts, decimal symbols, and decimal places.

Пайыз

Multiply the value by 100 and append a percent sign (%); follow the settings specified in the regional settings of Windows for negative amounts, decimal symbols, and decimal places.

Ғылыми

Use standard scientific notation.


Custom Formats

Custom number formats can have one to four sections with semicolons (;) as the list separator. Each section contains the format specification for a different type of number.

Бөлім

Сипаттама

Аты

The format for positive numbers.

Секунд

The format for negative numbers.

Үшінші

The format for zero values.

Төртінші

The format for Null values.


For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"

This number format contains four sections separated by semicolons and uses a different format for each section.

If you use multiple sections but don't specify a format for each section, entries for which there is no format will either display nothing or default to the formatting of the first section.

You can create custom number formats by using the following symbols.

symbol

Сипаттама

. (кезең)

Decimal separator. Separators are set in the regional settings in Windows.

, (үтір)

Thousand separator.

«#,0#»

Digit placeholder. Display a digit or 0.

#

Digit placeholder. Display a digit or nothing.

$

Display the literal character "$".

%

Percentage. The value is multiplied by 100 and a percent sign is appended.

E– or e–

Scientific notation with a minus sign (–) next to negative exponents and nothing next to positive exponents. This symbol must be used with other symbols, as in 0.00E–00 or 0.00E00.

E+ or e+

Scientific notation with a minus sign (–) next to negative exponents and a plus sign (+) next to positive exponents. This symbol must be used with other symbols, as in 0.00E+00.


Ескертпелер

You can use the DecimalPlaces property to override the default number of decimal places for the predefined format specified for the Format property.

The predefined currency and euro formats follow the settings in the regional settings of Windows. You can override these by entering your own currency format.

Мысал

The following are examples of the predefined number formats.

Параметр

Деректер

Көрсету

"General Number"

3456.789
–3456.789
$213.21

3456.789
–3456.789
$213.21

Валюта

3456.789
–3456.789

$3,456.79
($3,456.79)

"Fixed"

3456.789
–3456.789
3.56645

3456.79
–3456.79
3.57

Стандартты

3456.789

3,456.79

Пайыз

3
0.45

300%
45%

Ғылыми

3456.789
–3456.789

3.46E+03
–3.46E+03


The following are examples of custom number formats.

Параметр

Сипаттама

0;(0);;"Null"

Display positive values normally; display negative values in parentheses; display the word "Null" if the value is Null.

$#,##0.00_);($#,##0.00)

Display a plus (+) or minus (–) sign with positive or negative numbers; display 0.0 if the value is zero.


Ескерту : Machine Translation Disclaimer: This article has been translated by a computer system without human intervention. Microsoft offers these machine translations to help non-English speaking users enjoy content about Microsoft products, services and technologies. Because the article was machine translated, it may contain errors in vocabulary, syntax or grammar.

Дағдыларды жетілдіру
Оқыту курсымен танысыңыз
Жаңа мүмкіндіктерге бірінші болып қол жеткізу
Office Insider бағдарламасына қосылу

Осы ақпарат пайдалы болды ма?

Пікіріңіз үшін рақмет!

Пікіріңізге рақмет! Сізді Office қолдау көрсету қызметіндегі агенттердің бірімен байланыстырған жөн болуы мүмкін.

×