{"id":10810,"date":"2022-07-22T09:29:28","date_gmt":"2022-07-22T09:29:28","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=10810"},"modified":"2024-03-26T10:46:50","modified_gmt":"2024-03-26T10:46:50","slug":"change-character-separating-thousands-or-decimals","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/change-character-separating-thousands-or-decimals\/","title":{"rendered":"Change Character Separating Thousands or Decimals in Excel"},"content":{"rendered":"\n
In many countries such as the USA, UK, and Australia, a comma (,) is used for separating groups of thousands, and a period (.) is used as a decimal separator. Thus, in Excel, a currency value of two thousand and thirty-five dollars and twenty-five cents is displayed as 2,035.25. We will refer to this number format as the US number format<\/strong>.<\/p>\n\n\n\n However, in most European countries, a comma (,) is used as the decimal separator and a period (.) is used as the thousands separator. Thus, in Excel, the same currency value we referred to before would be displayed as 2.035,25 or 2 035,25 (groups of three digits separated by a thin space). We will refer to this number format as the European number format<\/strong>.<\/p>\n\n\n\n In this tutorial we will look at 5 different methods we can use to change numbers from the European number format to the US number format and vice versa.<\/p>\n\n\n\n In this method, we use the following steps to change the character separating thousands from the period (.) to comma (,) and the character separating decimals from comma (,) to decimal (.).<\/p>\n\n\n\n We will use the following dataset that has the Price column in European number format to show how the method works.<\/p>\n\n\n\nMethod 1: Use the Find and Replace feature in Excel<\/h2>\n\n\n\n
Change European number format to the US number format<\/h3>\n\n\n\n