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

Mechanicalengblog

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
  • 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

  • how to lock a word document from editing
  • How to insert page borders in ms word 2016
  • How to remove line breaks in word 2016
  • How to add bookmark and hyperlink in ms word
  • 2 ways to set long bond paper size in word
  • how to remove the background of a picture in word
  • How to insert checkbox in Word
  • How to insert and remove page break in word
  • How to draw shapes in Word?
  • Page number in word by roman numerals & numbers

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