{"id":12817,"date":"2022-12-20T12:54:21","date_gmt":"2022-12-20T12:54:21","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=12817"},"modified":"2024-03-26T10:46:50","modified_gmt":"2024-03-26T10:46:50","slug":"change-commas-to-dots-and-vice-versa","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/","title":{"rendered":"Change Commas to Dots and Vice Versa in Excel"},"content":{"rendered":"\n
Change-Commas-to-Dots-and-Vice-Versa<\/a>Download File<\/a><\/div>\n\n\n\n

The majority of English-speaking countries, including Australia, the UK, and the USA, use commas to separate groups of thousands and dots to separate decimals.<\/p>\n\n\n\n

Other countries such as France, Spain, and Denmark flip this around and use dots to separate groups of thousands and commas to separate decimals.<\/p>\n\n\n\n

Therefore, as you work with Excel in an international setting, sometimes you may be required to change commas to dots and vice versa to show numbers in a suitable format for your audience.<\/p>\n\n\n\n

This tutorial demonstrates five methods of changing commas to dots and vice versa in Excel.<\/p>\n\n\n\n

Method #1: Switch the System Separators in Excel Options Dialog Box<\/h2>\n\n\n\n

This technique uses the Excel Options<\/strong> dialog box to switch the system separators.<\/p>\n\n\n\n

Suppose we have received the following dataset from our contractor. He has used commas to separate groups of thousands and dots to separate decimals.<\/p>\n\n\n\n

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

We want to share the dataset with our partners who live in Spain, where they use dots to separate thousands and commas to separate decimals.<\/p>\n\n\n\n

We have to change the commas to dots and the dots to commas.<\/p>\n\n\n\n

We use the following steps:<\/p>\n\n\n\n

    \n
  1. Click File<\/strong> to open the Backstage<\/strong> window.<\/li>\n<\/ol>\n\n\n\n
    \"Graphical<\/figure>\n\n\n\n
      \n
    1. Choose Options<\/strong> on the left sidebar of the Backstage<\/strong> window.<\/li>\n<\/ol>\n\n\n\n
      \"A<\/figure>\n\n\n\n
        \n
      1. Click Advanced<\/strong> on the left sidebar of the Excel Options<\/strong> dialog box.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
          \n
        1. In the Editing Options<\/strong> segment of the dialog box, deselect the Use system separators<\/strong> option and replace the dot in the Decimal separator<\/strong> text box with a comma (,) and the comma in the Thousands separator<\/strong> text box with a dot (.) and click OK.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          The commas and dots in the example dataset are switched:<\/p>\n\n\n\n

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

          Note:<\/strong> To switch back to the default system separators, open the Excel Options<\/strong> dialog box and select the Use system separators<\/strong> option.<\/p>\n\n\n\n

          Method #2: Adjust the Windows Regional Settings<\/h2>\n\n\n\n

          This method involves adjusting the Windows regional settings to switch the system separators in the Excel Options dialog box.<\/p>\n\n\n\n

          In our demonstration, we use the following example dataset: commas separating groups of thousands and dots separating decimals.<\/p>\n\n\n\n

          \"Table,<\/figure>\n\n\n\n

          Our goal is to change the commas to dots and the dots, to commas.<\/p>\n\n\n\n

          We use the steps below:<\/p>\n\n\n\n

            \n
          1. From the Windows Search box, search and open the Contol Panel App<\/strong>.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
              \n
            1. In the Control Panel<\/strong> window, select Change date, time, or number formats<\/strong> under the Clock and Region<\/strong> option.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
                \n
              1. Click the Additional settings<\/strong> button in the Formats<\/strong> tab of the Region<\/strong> dialog box that appears.<\/li>\n<\/ol>\n\n\n\n
                \"\"<\/figure>\n\n\n\n
                  \n
                1. In the Numbers<\/strong> tab of the Customize Format<\/strong> dialog box, open the Decimal symbol<\/strong> drop-down and select the comma symbol. Then open the Digit grouping symbol<\/strong> drop-down and select the dot symbol.<\/li>\n<\/ol>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n
                    \n
                  1. Click Apply<\/strong> and OK<\/strong>.<\/li>\n\n\n\n
                  2. Click Apply<\/strong> and OK<\/strong> in the Region <\/strong>dialog box.<\/li>\n<\/ol>\n\n\n\n

                    When we open the Excel worksheet containing the dataset, we see that commas have been changed to dots, and the dots have been changed to commas.<\/p>\n\n\n\n

                    \"Table\n\nDescription<\/figure>\n\n\n\n

                    Please note that the changes we have made now affect all the applications on the computer. The dot has become the default system separator for thousands and the dot has become the default separator for decimals.<\/p>\n\n\n\n

                    If we want to restore the system\u2019s original default separators, we navigate to the Customize Format<\/strong> dialog box, as explained earlier in this Method #3<\/strong>, and click the Reset<\/strong> button in the Numbers<\/strong> tab.<\/p>\n\n\n\n

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

                    Click Yes<\/strong> on the message box that pops up.<\/p>\n\n\n\n

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

                    Click OK<\/strong> on the Customize Format<\/strong> dialog box and click Apply<\/strong> and OK <\/strong>on the Region<\/strong> dialog box.<\/p>\n\n\n\n

                    The system\u2019s default separators are restored.<\/p>\n\n\n\n

                    Method #3: Apply the Replace Feature of Notepad<\/h2>\n\n\n\n

                    This method involves copying the Excel data and pasting it into Notepad. We then switch the commas and dots in Notepad, copy the data, and paste it back into Excel.<\/p>\n\n\n\n

                    In our illustration, we use the following example dataset: commas separating groups of thousands and dots separating decimals.<\/p>\n\n\n\n

                    \"Table,<\/figure>\n\n\n\n

                    We want to change the commas to dots and the dots to commas.<\/p>\n\n\n\n

                    We use the steps below:<\/p>\n\n\n\n

                      \n
                    1. Select the dataset and press Ctrl + C<\/strong> to copy it.<\/li>\n<\/ol>\n\n\n\n
                      \"\"<\/figure>\n\n\n\n
                        \n
                      1. Search and open the Notepad App<\/strong> from the Windows search box.<\/li>\n<\/ol>\n\n\n\n
                        \"\"<\/figure>\n\n\n\n
                          \n
                        1. Press Ctrl + V<\/strong> to paste the data into the Notepad<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                          \"Text\n\nDescription<\/figure>\n\n\n\n
                            \n
                          1. Open the Notepad Replace<\/strong> dialog box in any of the following ways:<\/li>\n<\/ol>\n\n\n\n

                            Press Ctrl + H<\/strong><\/p>\n\n\n\n

                            Or<\/strong><\/p>\n\n\n\n

                            Select Replace on the Edit menu.<\/p>\n\n\n\n

                            \"Graphical<\/figure>\n\n\n\n
                              \n
                            1. In the Replace<\/strong> dialog box, type a dot in the Find what<\/strong> text box and a question mark (?) in the Replace with<\/strong> text box, then click the Replace All<\/strong> button.<\/li>\n<\/ol>\n\n\n\n
                              \"\"<\/figure>\n\n\n\n

                              Note:<\/strong> The question mark is a temporary placeholder that shall be replaced with a comma.<\/p>\n\n\n\n

                              \"Text\n\nDescription<\/figure>\n\n\n\n
                                \n
                              1. In the Replace <\/strong>dialog box, replace what is in the Find what<\/strong> box with a comma and what is in the Replace with<\/strong> box with a dot, then click the Replace All<\/strong> button.<\/li>\n<\/ol>\n\n\n\n
                                \"Graphical<\/figure>\n\n\n\n

                                The commas are replaced with dots.<\/p>\n\n\n\n

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

                                We now have to replace the question mark placeholders with commas.<\/p>\n\n\n\n

                                  \n
                                1. In the Replace<\/strong> dialog box, replace what is in the Find what<\/strong> box with a question mark (?) and what is in the Replace with<\/strong> box with a comma, then click the Replace All<\/strong> button.<\/li>\n<\/ol>\n\n\n\n
                                  \"Graphical<\/figure>\n\n\n\n

                                  Click the Cancel button to dismiss the Replace <\/strong>dialog box.<\/p>\n\n\n\n

                                  The question marks are replaced with commas. The commas have been changed to dots, and the dots have been changed to commas.<\/p>\n\n\n\n

                                  \"Text\n\nDescription<\/figure>\n\n\n\n
                                    \n
                                  1. Press Ctrl + A<\/strong> to select the dataset and Ctrl + C<\/strong> to copy it.<\/li>\n<\/ol>\n\n\n\n
                                    \"Graphical<\/figure>\n\n\n\n
                                      \n
                                    1. Open a new worksheet and press Ctrl + V<\/strong> to paste the dataset.<\/li>\n<\/ol>\n\n\n\n
                                      \"Graphical<\/figure>\n\n\n\n
                                        \n
                                      1. Format the dataset to make it appealing.<\/li>\n<\/ol>\n\n\n\n
                                        \"Table,<\/figure>\n\n\n\n

                                        Notice that the values in column C are left-aligned because they are text strings and, therefore, cannot be used in calculations.<\/p>\n\n\n\n

                                        Method #4: Use Excel Flash Fill Feature<\/h2>\n\n\n\n

                                        This method applies the Excel Flash Fill Feature to change the commas in a dataset to dots and vice versa. The Flash Fill feature fills in data automatically once it detects a pattern in the data.<\/p>\n\n\n\n

                                        We use the following dataset in our demonstration. Our goal is to change the comma separator to a dot and the dot separator to a comma using the Flash Fill feature.<\/p>\n\n\n\n

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

                                        We use the following steps:<\/p>\n\n\n\n

                                          \n
                                        1. Select cell D3 and enter the value 2.000,45. Select cell D4 and enter the value 1.500,52 as shown below:<\/li>\n<\/ol>\n\n\n\n
                                          \"\"<\/figure>\n\n\n\n

                                          Notice that Excel senses a pattern in the data and suggests the next values in grey.<\/p>\n\n\n\n

                                            \n
                                          1. Press Enter to accept the suggested values if they are correct.<\/li>\n<\/ol>\n\n\n\n
                                            \"Table,<\/figure>\n\n\n\n

                                            Note:<\/strong> If the Flash Fill<\/strong> feature does not show suggested values, select cell D5 after you have entered the two values, then do either of the following:<\/p>\n\n\n\n

                                            Press Ctrl + E<\/strong><\/p>\n\n\n\n

                                            Or<\/strong><\/p>\n\n\n\n

                                            In the Data<\/strong> tab, select Flash Fill<\/strong> in the Data Tools<\/strong> group.<\/p>\n\n\n\n

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

                                            The Flash Fill<\/strong> feature senses a pattern in the first two entries you entered and fills in the rest of the data.<\/p>\n\n\n\n

                                            Method #5: Use the SUBSTITUTE and FIXED Functions<\/h2>\n\n\n\n

                                            This method uses the SUBSTITUTE<\/strong> and FIXED<\/strong> functions to change commas to decimal points and decimal points to comas.<\/p>\n\n\n\n

                                            The SUBSTITUTE<\/strong> function substitutes a new text string for existing text in a text string. The FIXED <\/strong>function rounds a number to the specified number of decimals and returns the result as text with or without commas.<\/p>\n\n\n\n

                                            In our illustration, we use the following example dataset: commas separating groups of thousands and decimal points separating decimals.<\/p>\n\n\n\n

                                            \"Table,<\/figure>\n\n\n\n

                                            We want to change the commas to dots and the dots to commas.<\/p>\n\n\n\n

                                            We use the following steps:<\/p>\n\n\n\n

                                              \n
                                            1. Enter the following formula in cell D3:<\/li>\n<\/ol>\n\n\n\n
                                              =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FIXED(C3,2,FALSE),\".\",\"$\"),\",\",\".\"),\"$\",\",\")<\/code><\/pre>\n\n\n\n
                                              \"\"<\/figure>\n\n\n\n
                                                \n
                                              1. Click the Enter button on the formula bar to enter the formula.<\/li>\n<\/ol>\n\n\n\n
                                                \"Graphical<\/figure>\n\n\n\n
                                                  \n
                                                1. Drag down or double-click the fill handle to copy the formula down<\/a> the column.<\/li>\n<\/ol>\n\n\n\n
                                                  \"Table,<\/figure>\n\n\n\n
                                                  Explanation of the formula<\/h3>\n\n\n\n
                                                  =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FIXED(C3,2,FALSE),\".\",\"$\"),\",\",\".\"),\"$\",\",\")<\/code><\/pre>\n\n\n\n
                                                    \n
                                                  • SUBSTITUTE(FIXED(C3,2,FALSE),”.”,”$”)<\/strong> The innermost SUBSTITUTE function replaces the dots with dollar ($) signs.<\/li>\n<\/ul>\n\n\n\n
                                                    \"Graphical<\/figure>\n\n\n\n
                                                      \n
                                                    • SUBSTITUTE(SUBSTITUTE(FIXED(C3,2,FALSE),”.”,”$”),”,”,”.”) <\/strong>The second innermost SUBSTITUTE function replaces the commas with dots.<\/li>\n<\/ul>\n\n\n\n
                                                      \"\"<\/figure>\n\n\n\n
                                                        \n
                                                      • =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FIXED(C3,2,FALSE),”.”,”$”),”,”,”.”),”$”,”,”) <\/strong> The outermost SUBSTITUTE function replaces the dollar symbol ($) with a comma. The commas have been changed to dots and dots to commas.<\/li>\n<\/ul>\n\n\n\n
                                                        Conclusion<\/h2>\n\n\n\n
                                                        This tutorial showed five techniques for changing commas to dots and vice versa in Excel. We hope you found the tutorial helpful.<\/p>\n","protected":false},"excerpt":{"rendered":"
                                                        The majority of English-speaking countries, including Australia, the UK, and the USA, use commas to separate groups of thousands and dots to separate…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nChange Commas to Dots and Vice Versa in Excel<\/title>\n<meta name=\"description\" content=\"Learn five methods to change commas to dots and vice versa in Excel. Use the Excel Options dialog box to switch system separators to suit your audience.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change Commas to Dots and Vice Versa in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn five methods to change commas to dots and vice versa in Excel. Use the Excel Options dialog box to switch system separators to suit your audience.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-20T12:54:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T10:46:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Change Commas to Dots and Vice Versa in Excel\",\"datePublished\":\"2022-12-20T12:54:21+00:00\",\"dateModified\":\"2024-03-26T10:46:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/\"},\"wordCount\":1329,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/\",\"name\":\"Change Commas to Dots and Vice Versa in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png\",\"datePublished\":\"2022-12-20T12:54:21+00:00\",\"dateModified\":\"2024-03-26T10:46:50+00:00\",\"description\":\"Learn five methods to change commas to dots and vice versa in Excel. Use the Excel Options dialog box to switch system separators to suit your audience.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png\",\"width\":299,\"height\":173},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change Commas to Dots and Vice Versa in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Change Commas to Dots and Vice Versa in Excel","description":"Learn five methods to change commas to dots and vice versa in Excel. Use the Excel Options dialog box to switch system separators to suit your audience.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/","og_locale":"en_US","og_type":"article","og_title":"Change Commas to Dots and Vice Versa in Excel","og_description":"Learn five methods to change commas to dots and vice versa in Excel. Use the Excel Options dialog box to switch system separators to suit your audience.","og_url":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/","article_published_time":"2022-12-20T12:54:21+00:00","article_modified_time":"2024-03-26T10:46:50+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Change Commas to Dots and Vice Versa in Excel","datePublished":"2022-12-20T12:54:21+00:00","dateModified":"2024-03-26T10:46:50+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/"},"wordCount":1329,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/","url":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/","name":"Change Commas to Dots and Vice Versa in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png","datePublished":"2022-12-20T12:54:21+00:00","dateModified":"2024-03-26T10:46:50+00:00","description":"Learn five methods to change commas to dots and vice versa in Excel. Use the Excel Options dialog box to switch system separators to suit your audience.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/12\/word-image-12817-1.png","width":299,"height":173},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/change-commas-to-dots-and-vice-versa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Change Commas to Dots and Vice Versa in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12817"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=12817"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12817\/revisions"}],"predecessor-version":[{"id":15779,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12817\/revisions\/15779"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=12817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=12817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=12817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}