Method 1: converting decimal point to comma in Excel through Notepad To convert decimal point to comma in imported data you can use 4 methods: Delete everything from the sheet and open a new one for further work. In this case «General» format of cells (by default) can be changed, making it impossible to distinguish visually whether the number or the text has been recognized.Īll further actions should be performed on a blank worksheet. If you copy data from other sources without Paste Special, format is copied together with other data. In all cells the format is «General» by default. In other columns values are left aligned. In the dialog box select «Unicode Text» and click OK.Īs you can see, Excel recognizes only those numbers, which are located in column C. Select «Paste Special» option in the appeared shortcut menu. Now go to the worksheet and right-click cell A1. Highlight and copy data from the spreadsheet given below: № How to change decimal point to comma in Excel?
