{"id":1752,"date":"2021-11-08T09:20:14","date_gmt":"2021-11-08T00:20:14","guid":{"rendered":"https:\/\/kintools.com\/?post_type=docs&p=1752"},"modified":"2021-11-08T11:05:02","modified_gmt":"2021-11-08T02:05:02","password":"","slug":"numerical-formatting","status":"publish","type":"docs","link":"https:\/\/kintools.com\/en\/docs\/numerical-formatting\/","title":{"rendered":"Number format"},"content":{"rendered":"

We recommend that you use the number format to display numbers. Below is a report that includes a list of products, their prices, and key products and categories. By default, all text components use the general text format without formatting.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Set the numeric format of ProductID, CategoryID, and UnitPrice. To do this, select the text component that contains the reference to the relevant data column and click the Text Format Properties button. In the Format dialog box, open the Numbers tab and configure your settings.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Keep in mind that there were two ways to determine the format mask.<\/p>\n\n\n\n

\"\"Use local settings. The text will be formatted according to the operating system's current settings.<\/p>\n\n\n\n

\"\" Each parameter is manually defined by the format mask.<\/p>\n\n\n\n

In both cases, there were some disadvantages. For example, if you want to change the format parameters in the local settings, you need to edit the OS format. In the second case, if you need to change one parameter, you need to adjust the other parameters as well. Considering the disadvantages of these methods, there is a third way to determine the format. You can change any parameter format using local settings. To do this, set the flag next to the parameter and set its value.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\"\"  Group separator <\/strong><\/p>\n\n\n\n

If you use a group separator, the numbers are separated into numerical positions.<\/p>\n\n\n\n

\"\"  Local settings <\/strong><\/p>\n\n\n\n

If you use local settings, the numbers will be formatted for the currently installed OS.<\/p>\n\n\n\n

\"\" Number of digits after the decimal point<\/strong><\/p>\n\n\n\n

The number of digits after the decimal point, used for number formatting.<\/p>\n\n\n\n

\"\" Decimal separator<\/strong><\/p>\n\n\n\n

Used as a decimal delimiter to separate numbers in formatting.<\/p>\n\n\n\n

\"\" Group separator<\/strong><\/p>\n\n\n\n

Used as a group separator when formatting numbers.<\/p>\n\n\n\n

\"\"Group size<\/strong><\/p>\n\n\n\n

The number of digits in each group in the currency value format.<\/p>\n\n\n\n

\"\"Negative pattern<\/strong><\/p>\n\n\n\n

This pattern is used for negative value formats.
Therefore, in the ProductID and CategoryID columns, change only the number of digits in the fractional part.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\" caution: <\/strong>You must use the currency format to display currency values. In the above example, the currency format is set in the UnitPrice column.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>","protected":false},"excerpt":{"rendered":"

\u6570\u5024\u3092\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u6570\u5024\u5f62\u5f0f\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002\u4ee5\u4e0b\u306f\u3001\u88fd\u54c1\u306e\u30ea\u30b9\u30c8\u3001\u305d\u308c\u3089\u306e\u4fa1\u683c\u3001\u304a\u3088\u3073\u4e3b\u8981\u306a\u88fd\u54c1 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"doc_category":[74],"doc_tag":[],"class_list":["post-1752","docs","type-docs","status-publish","hentry","doc_category-text-formatting","entry"],"year_month":"2026-05","word_count":18,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"yuko.imai","author_nicename":"yuko-imai","author_url":"https:\/\/kintools.com\/en\/author\/yuko-imai\/"},"doc_category_info":[{"term_name":"\u30c6\u30ad\u30b9\u30c8\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8","term_url":"https:\/\/kintools.com\/en\/docs-category\/text-formatting\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/comments?post=1752"}],"version-history":[{"count":3,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1752\/revisions"}],"predecessor-version":[{"id":1768,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1752\/revisions\/1768"}],"wp:attachment":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/media?parent=1752"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_category?post=1752"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_tag?post=1752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}