• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar

Mechanicaleng blog

siemens nx tutorial & injection molding technology

  • Plastic molding
  • Siemens nx
    • nx modeling
    • nx drafting
    • nx sketching
    • nx assembly
  • Mechanical basic
    • mechanical standard
    • Mechanism video
  • microsoft office
    • microsoft word
    • powerpoint
    • excel tips
  • About me
  • CONTACT ME
Home » microsoft office » excel tips » 2 ways to convert comma to dot in excel

2 ways to convert comma to dot in excel

February 28, 2021 by mechanicaleng blog Leave a Comment

Data entered in Excel will automatically be separated by dots or commas. Users can use those to separate units in the sequence more clearly. However, if in a document the unit separator is not uniform, you need to switch back to the same type of sign. The following article will guide you how to convert comma into dot or vice versa in Excel.

Method 1: convert comma to dot in excel by using the Find & Select Tool.

Step 1: Open the Excel spreadsheet you need to update. Click on the Find & Select button. Click Replace from the menu.

convert comma to dot in excel by using the Find & Select Tool 1

Step 2: A window will open with two fields. In the “Find what” field, type in a comma. In the “Replace with” field, type in a period/dot and vice versa if you want to change from dot to comma.

convert comma to dot in excel by using the Find & Select Tool 2

Step 3: Click Replace you will see the change with data. Or Replace all to replace every comma in the document with a period/dot.

convert comma to dot in excel by using the Find & Select Tool 3

Method 2: Changing Number Separators

Step 1: Open the Excel spreadsheet you need to update. Click File in the top left corner. Then select Options in the bottom left corner.

convert comma to dot Changing Number Separators 4
Step 2: Click Advanced in the menu on the left. A window of Excel Options will pop up that has another menu along the left side. Uncheck the Use system separators box.

convert comma to dot Changing Number Separators 5

Step 3: Update the Decimal separator and Thousands separator fields as necessary. Depending on what your defaults are, one of these fields should have a comma in it. Replace it with a period/dot and click “OK” at the bottom of the window to complete the change.

Basically, the operation to change the dot to a comma on Excel with the versions is the same, you also need to remove the automatic separation of the system and then adjust it according to your needs We can use the same type of separator or two types of markers at the same time. Hope this article will be useful for you, wish you success!

Related posts:

Create border in excel by border tool2 ways to create border in excel print multiple sheets all sheets in Excel 3How to print multiple sheets in Excel? How to count blank cells in excelHow to count and color blank cells in excel change cell background color automatically in excelchange cell background color in excel by equal formulas

Filed Under: excel tips Tagged With: excel beginner, excel tutorial

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • what is spur gear | introduction
  • Mechanical engineering skills from training process
  • What is Inox | Stainless Steel?
  • How to create thread in nx
  • nx assembly| create a new part from the same part
  • how to calculate sum of squares in Excel
  • How to active GC toolkits in Siemens NX
  • How to create a sphere in nx
  • How to create a cone in nx
  • How to create a cylinder in nx

Copyright © 2023 · Magazine Pro on Genesis Framework · WordPress · Log in