{"id":1756,"date":"2021-11-08T09:45:13","date_gmt":"2021-11-08T00:45:13","guid":{"rendered":"https:\/\/kintools.com\/?post_type=docs&p=1756"},"modified":"2021-11-08T09:45:13","modified_gmt":"2021-11-08T00:45:13","password":"","slug":"currency-formatting","status":"publish","type":"docs","link":"https:\/\/kintools.com\/en\/docs\/currency-formatting\/","title":{"rendered":"Currency format"},"content":{"rendered":"

To display the number as currency, use the Currency format. This format is specifically designed to output currency values.<\/p>\n\n\n\n

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

Sets the currency format for the Unit Price column.<\/p>\n\n\n\n

\"\"\u00a0information:<\/strong><\/strong>An important point when setting a currency format is the choice of currency you need.
The same value can be one of the currencies of the United States, the European Union, China, and other countries.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

For example, prices are displayed in US dollars. Then select the appropriate currency symbol and determine the format parameters.<\/p>\n\n\n\n

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

Previously, there were two ways to determine the format mask.<\/p>\n\n\n\n

\"\"\u00a0Local settings format the text according to the operating system's current settings.<\/p>\n\n\n\n

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

In both cases, there may be 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

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

Group separators separate currency values into numeric positions.<\/p>\n\n\n\n

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

If you use the local setting, the currency value will be formatted according to the current OS installation.<\/p>\n\n\n\n

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

The number of decimal places, which is used to format the value of the currency.<\/p>\n\n\n\n

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

Used as a decimal delimiter to separate currency values in the format.<\/p>\n\n\n\n

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

Used as a group separator when currency values are formatted<\/p>\n\n\n\n

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

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

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

This pattern is used to format positive values.<\/p>\n\n\n\n

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

This pattern is used for negative value formats<\/p>\n\n\n\n

\"\"\u00a0Currency symbol<\/strong><\/p>\n\n\n\n

This symbol is used to define the currency name.<\/p>\n\n\n\n

Let's return to the above example. Change only the "Positive Pattern" and "Currency Symbol" parameters. Other parameters are determined by local settings.<\/p>\n\n\n\n

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

\u6570\u5024\u3092\u901a\u8ca8\u3068\u3057\u3066\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u901a\u8ca8\uff08Currency\uff09\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u3053\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306f\u3001\u7279\u306b\u901a\u8ca8\u306e […]<\/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-1756","docs","type-docs","status-publish","hentry","doc_category-text-formatting","entry"],"year_month":"2026-05","word_count":4,"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\/1756","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=1756"}],"version-history":[{"count":1,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1756\/revisions"}],"predecessor-version":[{"id":1757,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1756\/revisions\/1757"}],"wp:attachment":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/media?parent=1756"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_category?post=1756"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_tag?post=1756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}